Micron Document
<!DOCTYPE html>
<html class="client-nojs vector-feature-night-mode-disabled vector-feature-language-in-header-enabled vector-feature-language-in-main-page-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref-1 vector-feature-appearance-pinned-clientpref-1 vector-sticky-header-enabled" lang="en" dir="ltr"><head>
<meta charset="UTF-8">
<title>Entity Framework</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="canonical" href="https://en.wikipedia.org/wiki/Entity_Framework"> <link href="./mw/ext.cite.styles.css" rel="stylesheet" type="text/css">
<link href="./mw/ext.pygments.css" rel="stylesheet" type="text/css">
<link href="./mw/skins.vector.icons.css" rel="stylesheet" type="text/css">
<link href="./mw/skins.vector.search.codex.styles.css" rel="stylesheet" type="text/css">
<link href="./mw/skins.vector.styles.css" rel="stylesheet" type="text/css">
<link href="./mw/user.styles.css" rel="stylesheet" type="text/css">
<meta name="ResourceLoaderDynamicStyles" content="">
<link rel="stylesheet" type="text/css" href="./mw/site.styles.css">
<link rel="stylesheet" type="text/css" href="./mw/noscript.css">
<link rel="stylesheet" type="text/css" href="./footer.css">
<link rel="stylesheet" type="text/css" href="./vector-2022.css">
</head>
<body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-0 ns-subject page-Entity_Framework rootpage-Entity_Framework skin-vector-2022 action-view">
<div class="mw-page-container">
<div class="mw-page-container-inner">
<div class="mw-content-container">
<main id="content" class="mw-body">
<header class="mw-body-header vector-page-titlebar">
<h1 id="firstHeading" class="firstHeading mw-first-heading">
<span id="openzim-page-title" class="mw-page-title-main"><span class="mw-page-title-main">Entity Framework</span></span>
</h1>
</header>
<a id="top"></a>
<div id="bodyContent" class="vector-body ve-init-mw-desktopArticleTarget-targetContainer" aria-labelledby="firstHeading" data-mw-ve-target-container="">
<div id="mw-content-text" class="mw-body-content mw-content-ltr" lang="en" dir="ltr"><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr">
<style data-mw-deduplicate="TemplateStyles:r1295905060">
/* start https://en.wikipedia.org/ */


.mw-parser-output .infobox-subbox{padding:0;border:none;margin:-3px;width:auto;min-width:100%;font-size:100%;clear:none;float:none;background-color:transparent}.mw-parser-output .infobox-3cols-child{margin:auto}.mw-parser-output .infobox .navbar{font-size:100%}@media screen{html.skin-theme-clientpref-night .mw-parser-output .infobox-full-data:not(.notheme)>div:not(.notheme)[style]{background:#1f1f23!important;color:#f8f9fa}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .infobox-full-data:not(.notheme)>div:not(.notheme)[style]{background:#1f1f23!important;color:#f8f9fa}}@media(min-width:640px){body.skin--responsive .mw-parser-output .infobox-table{display:table!important}body.skin--responsive .mw-parser-output .infobox-table>caption{display:table-caption!important}body.skin--responsive .mw-parser-output .infobox-table>tbody{display:table-row-group}body.skin--responsive .mw-parser-output .infobox-table th,body.skin--responsive .mw-parser-output .infobox-table td{padding-left:inherit;padding-right:inherit}}


/* end https://en.wikipedia.org/ */
</style><table class="infobox vevent"><tbody><tr><th colspan="2" class="infobox-above summary">Entity Framework</th></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Programmer" title="Programmer">Original author(s)</a></th><td class="infobox-data"><a href="Microsoft" title="Microsoft">Microsoft</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Programmer" title="Programmer">Developer(s)</a></th><td class="infobox-data"><a href=".NET_Foundation" title=".NET Foundation">.NET Foundation</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;">Initial release</th><td class="infobox-data">August&nbsp;11, 2008<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2008-08-11</span>)</span></td></tr><tr style="display: none;"><td colspan="2" class="infobox-full-data"></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Software_release_life_cycle" title="Software release life cycle">Stable release</a></th><td class="infobox-data"><div style="margin:0px;">Entity Framework 6: v6.4.4<hr>Entity Framework Core: v9.0.4
/ Entity Framework Core: April&nbsp;8, 2025<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2025-04-08</span>)</span><sup id="cite_ref-CoreVer_1-0" class="reference"><a href="#cite_note-CoreVer-1"><span class="cite-bracket">[</span>1<span class="cite-bracket">]</span></a></sup></div></td></tr><tr style="display:none"><td colspan="2">
</td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Repository_(version_control)" title="Repository (version control)">Repository</a></th><td class="infobox-data"><span class="url"><a rel="nofollow" class="external text" href="https://github.com/dotnet/ef6">github<wbr>.com<wbr>/dotnet<wbr>/ef6</a></span><hr><span class="url"><a rel="nofollow" class="external text" href="https://github.com/dotnet/efcore">github<wbr>.com<wbr>/dotnet<wbr>/efcore</a></span></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;">Written in</th><td class="infobox-data"><a href="C_Sharp_(programming_language)" title="C Sharp (programming language)">C#</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Computing_platform" title="Computing platform">Platform</a></th><td class="infobox-data"><a href=".NET_Framework" title=".NET Framework">.NET Framework</a>,<br><a href=".NET_Core" class="mw-redirect" title=".NET Core">.NET Core</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Software_categories#Categorization_approaches" title="Software categories">Type</a></th><td class="infobox-data"><a href="Object%E2%80%93relational_mapping" title="Object–relational mapping">Object–relational mapping</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;"><a href="Software_license" title="Software license">License</a></th><td class="infobox-data"><a href="Apache_License_2.0" class="mw-redirect" title="Apache License 2.0">Apache License 2.0</a></td></tr><tr><th scope="row" class="infobox-label" style="white-space: nowrap;">Website</th><td class="infobox-data"><span class="url"><a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/">learn<wbr>.microsoft<wbr>.com<wbr>/en-us<wbr>/ef<wbr>/</a></span></td></tr></tbody></table>
<p><b>Entity Framework</b> (<b>EF</b>) is an open source<sup id="cite_ref-2" class="reference"><a href="#cite_note-2"><span class="cite-bracket">[</span>2<span class="cite-bracket">]</span></a></sup> <a href="Object%E2%80%93relational_mapping" title="Object–relational mapping">object–relational mapping</a> (ORM) framework for <a href="ADO.NET" title="ADO.NET">ADO.NET</a>. It was originally shipped as an integral part of <a href=".NET_Framework" title=".NET Framework">.NET Framework</a>, however starting with Entity Framework version 6.0 it has been delivered separately from the .NET Framework.
</p><p>Entity Framework 6.4 was the latest release of the classic framework. Although Entity Framework 6 is still supported, it is no longer being developed and will only receive fixes for security issues.<sup id="cite_ref-3" class="reference"><a href="#cite_note-3"><span class="cite-bracket">[</span>3<span class="cite-bracket">]</span></a></sup>
</p><p>A new framework known as Entity Framework Core (EF Core) was introduced in 2016 with similar but not complete feature parity.<sup id="cite_ref-4" class="reference"><a href="#cite_note-4"><span class="cite-bracket">[</span>4<span class="cite-bracket">]</span></a></sup> Version numbering of this framework restarted from 1.0 and the latest version of EF Core is 9.0.4.<sup id="cite_ref-5" class="reference"><a href="#cite_note-5"><span class="cite-bracket">[</span>5<span class="cite-bracket">]</span></a></sup>
</p>
<meta property="mw:PageProp/toc">
<div class="mw-heading mw-heading2"><h2 id="Overview">Overview</h2></div>
<p>The Entity Framework is a set of technologies in <a href="ADO.NET" title="ADO.NET">ADO.NET</a> that supports the development of data-oriented software applications. Architects and developers of data-oriented applications have typically struggled with the need to achieve two very different objectives. They must model the entities, relationships, and logic of the business problems they are solving, and they must also work with the data engines used to store and retrieve the data. The data can span multiple storage systems, each with its own protocols; even applications that work with a single storage system must balance the requirements of the storage system against the requirements of writing efficient and maintainable application code. This problem is generally referred to as the "<a href="Object%E2%80%93relational_impedance_mismatch" title="Object–relational impedance mismatch">object–relational impedance mismatch</a>".<sup id="cite_ref-6" class="reference"><a href="#cite_note-6"><span class="cite-bracket">[</span>6<span class="cite-bracket">]</span></a></sup>
</p><p>Many <a href="Object%E2%80%93relational_mapping" title="Object–relational mapping">object–relational mapping</a> (ORM) tools (aka "object–relational managers") have been developed to enable developers to work with data in the form of domain-specific objects and properties, such as customers and customer addresses, without having to concern themselves with the underlying database tables and columns where this data is stored. With an ORM, developers can work at a higher level of abstraction when they deal with data, and can create and maintain data-oriented applications with less code than in traditional applications. Entity Framework is the ORM solution currently promoted for use within the Microsoft development stack.<sup id="cite_ref-7" class="reference"><a href="#cite_note-7"><span class="cite-bracket">[</span>7<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-heading mw-heading2"><h2 id="History">History</h2></div>
<p>The first version of Entity Framework (EFv1) was included with .NET Framework 3.5 Service Pack 1 and <a href="Microsoft_Visual_Studio" class="mw-redirect" title="Microsoft Visual Studio">Visual Studio 2008</a> Service Pack 1, released on 11&nbsp;August 2008<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2008-08-11</span>)</span>. This version was widely criticized, even attracting a 'vote of no confidence' signed by at least one thousand developers.<sup id="cite_ref-vonc_8-0" class="reference"><a href="#cite_note-vonc-8"><span class="cite-bracket">[</span>8<span class="cite-bracket">]</span></a></sup>
</p><p>The second version of Entity Framework, named Entity Framework 4.0 (EFv4), was released as part of .NET 4.0 on 12 April 2010 and addressed many of the criticisms made of version 1.<sup id="cite_ref-verfour_9-0" class="reference"><a href="#cite_note-verfour-9"><span class="cite-bracket">[</span>9<span class="cite-bracket">]</span></a></sup>
</p><p>A third version of Entity Framework, version 4.1, was released on April 12, 2011, with Code First support.
</p><p>A refresh of version 4.1, named Entity Framework 4.1 Update 1, was released on July 25, 2011. It includes bug fixes and new supported types.
</p><p>The version 4.3.1 was released on February 29, 2012.<sup id="cite_ref-verfourthreeone_10-0" class="reference"><a href="#cite_note-verfourthreeone-10"><span class="cite-bracket">[</span>10<span class="cite-bracket">]</span></a></sup> There were a few updates, like support for migration.
</p><p>Version 5.0.0 was released on August 11, 2012<sup id="cite_ref-verfive_11-0" class="reference"><a href="#cite_note-verfive-11"><span class="cite-bracket">[</span>11<span class="cite-bracket">]</span></a></sup> and is targeted at .NET framework 4.5.
Also, this version is available for .Net framework 4, but without any runtime advantages over version 4.
</p><p>Version 6.0 was released on October 17, 2013<sup id="cite_ref-versionsix_12-0" class="reference"><a href="#cite_note-versionsix-12"><span class="cite-bracket">[</span>12<span class="cite-bracket">]</span></a></sup> and is now an open source project licensed under <a href="Apache_License" title="Apache License">Apache License</a> v2. Like <a href="ASP.NET_MVC" title="ASP.NET MVC">ASP.NET MVC</a>, its source code is hosted at <a href="GitHub" title="GitHub">GitHub</a> using Git.<sup id="cite_ref-13" class="reference"><a href="#cite_note-13"><span class="cite-bracket">[</span>13<span class="cite-bracket">]</span></a></sup> This version has a number of improvements for code-first support.<sup id="cite_ref-versiximprovements_14-0" class="reference"><a href="#cite_note-versiximprovements-14"><span class="cite-bracket">[</span>14<span class="cite-bracket">]</span></a></sup>
</p><p>Microsoft then decided to modernize, componentize and bring .NET cross-platform to Linux, OSX and elsewhere, meaning the next version of Entity Framework would be a complete rewrite.<sup id="cite_ref-versionseven_15-0" class="reference"><a href="#cite_note-versionseven-15"><span class="cite-bracket">[</span>15<span class="cite-bracket">]</span></a></sup> On 27 June 2016 this was released as Entity Framework Core 1.0, alongside ASP.NET Core 1.0 and .NET Core 1.0.<sup id="cite_ref-efcore-10-available_16-0" class="reference"><a href="#cite_note-efcore-10-available-16"><span class="cite-bracket">[</span>16<span class="cite-bracket">]</span></a></sup> It was originally named Entity Framework 7, but was renamed to highlight that it was a complete rewrite rather than an incremental upgrade and it doesn't replace EF6.<sup id="cite_ref-17" class="reference"><a href="#cite_note-17"><span class="cite-bracket">[</span>17<span class="cite-bracket">]</span></a></sup>
</p><p>Entity Framework Core 1.0 is licensed under <a href="Apache_License" title="Apache License">Apache License</a> v2, and was built entirely in the open on <a rel="nofollow" class="external text" href="https://github.com/aspnet/EntityFramework">GitHub</a>. While Entity Framework Core 1.0 shares some conceptual similarities with prior versions of Entity Framework, it was a completely new codebase designed to be more efficient, powerful, flexible, and extensible, running on Windows, Linux and OSX, and supporting a new range of relational and <a href="NoSQL" title="NoSQL">NoSQL</a> data stores.<sup id="cite_ref-versionseven_15-1" class="reference"><a href="#cite_note-versionseven-15"><span class="cite-bracket">[</span>15<span class="cite-bracket">]</span></a></sup>
</p><p>Entity Framework Core 2.0 was released on 14&nbsp;August 2017<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2017-08-14</span>)</span> along with Visual Studio 2017 15.3 and ASP.NET Core 2.0 <sup id="cite_ref-18" class="reference"><a href="#cite_note-18"><span class="cite-bracket">[</span>18<span class="cite-bracket">]</span></a></sup>
</p><p>Entity Framework Core 3.0 was released on 23&nbsp;September 2019<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2019-09-23</span>)</span> along with Visual Studio 2019 16.3 and ASP.NET Core 3.0,<sup id="cite_ref-19" class="reference"><a href="#cite_note-19"><span class="cite-bracket">[</span>19<span class="cite-bracket">]</span></a></sup>
</p><p>Entity Framework Core 3.1 (EF Core 3.1) was formally released for production use on 3&nbsp;December 2019<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2019-12-03</span>)</span> and will be the preferred long-term supported version until at least 3 December 2022.<sup id="cite_ref-EF_Core_releases_and_planning_20-0" class="reference"><a href="#cite_note-EF_Core_releases_and_planning-20"><span class="cite-bracket">[</span>20<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-nuget.org_21-0" class="reference"><a href="#cite_note-nuget.org-21"><span class="cite-bracket">[</span>21<span class="cite-bracket">]</span></a></sup>
</p><p>Entity Framework Core 5.0 (EF Core 5) was released for production use on 9&nbsp;November 2020<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2020-11-09</span>)</span>.<sup id="cite_ref-EF_Core_releases_and_planning_20-1" class="reference"><a href="#cite_note-EF_Core_releases_and_planning-20"><span class="cite-bracket">[</span>20<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-nuget.org_21-1" class="reference"><a href="#cite_note-nuget.org-21"><span class="cite-bracket">[</span>21<span class="cite-bracket">]</span></a></sup> It was retired and out of support 1.5 years later on May 10, 2022.<sup id="cite_ref-22" class="reference"><a href="#cite_note-22"><span class="cite-bracket">[</span>22<span class="cite-bracket">]</span></a></sup>
</p><p>Entity Framework Core 6.0 (EF Core 6) was released on 10&nbsp;November 2021<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2021-11-10</span>)</span><sup id="cite_ref-23" class="reference"><a href="#cite_note-23"><span class="cite-bracket">[</span>23<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-24" class="reference"><a href="#cite_note-24"><span class="cite-bracket">[</span>24<span class="cite-bracket">]</span></a></sup> and will be the preferred long-term supported version until at least 12 November 2024.<sup id="cite_ref-25" class="reference"><a href="#cite_note-25"><span class="cite-bracket">[</span>25<span class="cite-bracket">]</span></a></sup>
</p><p>Entity Framework Core 7.0 (EF Core 7) was released on 8&nbsp;November 2022<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2022-11-08</span>)</span><sup id="cite_ref-26" class="reference"><a href="#cite_note-26"><span class="cite-bracket">[</span>26<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-27" class="reference"><a href="#cite_note-27"><span class="cite-bracket">[</span>27<span class="cite-bracket">]</span></a></sup> adding features such as <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-7.0/whatsnew#json-columns">JSON columns</a> and <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-7.0/whatsnew#executeupdate-and-executedelete-bulk-updates">bulk updates</a>.
</p><p>Entity Framework Core 8.0 (EF Core 8) was released on 14&nbsp;November 2023<span style="display:none">&nbsp;(<span class="bday dtstart published updated">2023-11-14</span>)</span><sup id="cite_ref-28" class="reference"><a href="#cite_note-28"><span class="cite-bracket">[</span>28<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-29" class="reference"><a href="#cite_note-29"><span class="cite-bracket">[</span>29<span class="cite-bracket">]</span></a></sup> adding features such as <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-8.0/whatsnew#value-objects-using-complex-types">Value objects using Complex Types</a> and <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-8.0/whatsnew#primitive-collections">Primitive collections</a>.
</p>
<div class="mw-heading mw-heading2"><h2 id="Architecture">Architecture</h2></div>
<style data-mw-deduplicate="TemplateStyles:r1034237262">
/* start https://en.wikipedia.org/ */


.mw-parser-output .stack{box-sizing:border-box}.mw-parser-output .stack>div{margin:1px;overflow:hidden}@media all and (min-width:720px){.mw-parser-output .stack-clear-left{float:left;clear:left}.mw-parser-output .stack-clear-right{float:right;clear:right}.mw-parser-output .stack-left{float:left}.mw-parser-output .stack-right{float:right}.mw-parser-output .stack-margin-clear-left{float:left;clear:left;margin-right:1em}.mw-parser-output .stack-margin-clear-right{float:right;clear:right;margin-left:1em}.mw-parser-output .stack-margin-left{float:left;margin-right:1em}.mw-parser-output .stack-margin-right{float:right;margin-left:1em}}


/* end https://en.wikipedia.org/ */
</style><div class="stack mw-stack stack-right"><div></div></div>
<p>The architecture of the ADO.NET Entity Framework, from the bottom up, consists of the following:
</p>
<ul><li><b>Data source specific providers</b>, which abstract the ADO.NET interfaces to connect to the database when programming against the conceptual schema.</li>
<li><b>Map provider</b>, a database-specific provider that translates the Entity SQL command tree into a query in the native SQL flavor of the database. It includes the <b>Store-specific bridge</b>, which is the component responsible for translating the generic command tree into a store-specific command tree.</li>
<li><b><a href="#Entity_Data_Model">EDM</a> parser and view mapping</b>, which takes the SDL specification of the data model and how it maps onto the underlying relational model and enables programming against the conceptual model. From the relational schema, it creates views of the data corresponding to the conceptual model. It aggregates information from multiple tables in order to aggregate them into an entity, and splits an update to an entity into multiple updates to whichever table(s) contributed to that entity.</li>
<li><b>Query and update pipeline</b>, processes queries, filters and updates requests to convert them into canonical command trees which are then converted into store-specific queries by the map provider.</li>
<li><b>Metadata services</b>, which handle all metadata related to entities, relationships and mappings.</li>
<li><b>Transactions</b>, to integrate with transactional capabilities of the underlying store. If the underlying store does not support transactions, support for it needs to be implemented at this layer.</li>
<li><b>Conceptual layer API</b>, the runtime that exposes the programming model for coding against the conceptual schema. It follows the ADO.NET pattern of using Connection objects to refer to the map provider, using Command objects to send the query, and returning EntityResultSets or EntitySets containing the result.</li>
<li><b>Disconnected components</b>, which locally cache datasets and entity sets for using the ADO.NET Entity Framework in an occasionally connected environment.</li>
<li><b>Embedded database</b>: ADO.NET Entity Framework includes a lightweight embedded database for client-side caching and querying of relational data.</li>
<li><b>Design tools</b>, such as Mapping Designer, are also included with ADO.NET Entity Framework, which simplifies the job of mapping a conceptual schema to the relational schema and specifying which properties of an entity type correspond to which table in the database.</li>
<li><b>Programming layer</b>, which exposes the EDM as programming constructs which can be consumed by programming languages.
<ul><li><b>Object services</b>, automatically generate code for CLR classes that expose the same properties as an entity, thus enabling instantiation of entities as .NET objects.</li>
<li><b>Web services</b>, which expose entities as web services.</li></ul></li>
<li><b>High-level services</b>, such as reporting services which work on entities rather than relational data.</li></ul>
<div class="mw-heading mw-heading2"><h2 id="Entity_Data_Model">Entity Data Model</h2></div>
<p>The <b>Entity Data Model</b> (<b>EDM</b>) specifies the conceptual model (CSDL) of the data, using a modelling technique that is itself called Entity Data Model, an extended version of the <i><a href="Entity%E2%80%93relationship_model" title="Entity–relationship model">entity–relationship model</a></i>.<sup id="cite_ref-entitydatamodel_30-0" class="reference"><a href="#cite_note-entitydatamodel-30"><span class="cite-bracket">[</span>30<span class="cite-bracket">]</span></a></sup>
The data model primarily describes the <i><a href="https://en.wiktionary.org/wiki/entity" class="extiw external" title="wikt:entity">Entities</a></i> and the <i>Associations</i> they participate in. The EDM schema is expressed in the <i>Schema Definition Language</i> (SDL), which is an application of XML (Extended markup language). In addition, the mapping (MSL) of the elements of the conceptual schema (CSDL) to the storage schema (SSDL) must also be specified. The mapping specification is also expressed in XML.<sup id="cite_ref-CsdlMslSsdl_31-0" class="reference"><a href="#cite_note-CsdlMslSsdl-31"><span class="cite-bracket">[</span>31<span class="cite-bracket">]</span></a></sup>
</p>

<p>Visual Studio also provides the <i>Entity Designer</i> for visual creation of the EDM and the mapping specification. This approach is named as "Model First" approach, as alternatives to "Code First" and "Database First" approaches. The output of the tool is the XML file (*.edmx) specifying the schema and the mapping. Edmx file contains EF metadata artifacts (CSDL/MSL/SSDL content). These three files (csdl, msl, ssdl) can also be created or edited by hand. The "Model First" approach is not going to be supported in EF Core version. <sup id="cite_ref-32" class="reference"><a href="#cite_note-32"><span class="cite-bracket">[</span>32<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-heading mw-heading3"><h3 id="Mapping">Mapping</h3></div>
<p>Entity Data Model Wizard<sup id="cite_ref-EdmWizard_33-0" class="reference"><a href="#cite_note-EdmWizard-33"><span class="cite-bracket">[</span>33<span class="cite-bracket">]</span></a></sup> in Visual Studio initially generates a one-to-one (1:1) mapping between the database schema and the conceptual schema in most of the cases. In the relational schema, the elements are composed of the tables, with the primary and foreign keys gluing the related tables together. In contrast, the <i>Entity Types</i> define the conceptual schema of the data.
</p><p>The entity types are an aggregation of multiple typed fields – each field maps to a certain column in the database – and can contain information from multiple physical tables. The entity types can be related to each other, independent of the relationships in the physical schema. Related entities are also exposed similarly – via a field whose name denotes the relation they are participating in and accessing which, instead of retrieving the value from some column in the database, traverses the relationship and returns the entity (or a collection of entities) with which it is related.
</p>
<style data-mw-deduplicate="TemplateStyles:r1251242444">
/* start https://en.wikipedia.org/ */


.mw-parser-output .ambox{border:1px solid #a2a9b1;border-left:10px solid #36c;background-color:#fbfbfb;box-sizing:border-box}.mw-parser-output .ambox+link+.ambox,.mw-parser-output .ambox+link+style+.ambox,.mw-parser-output .ambox+link+link+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+style+.ambox,.mw-parser-output .ambox+.mw-empty-elt+link+link+.ambox{margin-top:-1px}html body.mediawiki .mw-parser-output .ambox.mbox-small-left{margin:4px 1em 4px 0;overflow:hidden;width:238px;border-collapse:collapse;font-size:88%;line-height:1.25em}.mw-parser-output .ambox-speedy{border-left:10px solid #b32424;background-color:#fee7e6}.mw-parser-output .ambox-delete{border-left:10px solid #b32424}.mw-parser-output .ambox-content{border-left:10px solid #f28500}.mw-parser-output .ambox-style{border-left:10px solid #fc3}.mw-parser-output .ambox-move{border-left:10px solid #9932cc}.mw-parser-output .ambox-protection{border-left:10px solid #a2a9b1}.mw-parser-output .ambox .mbox-text{border:none;padding:0.25em 0.5em;width:100%}.mw-parser-output .ambox .mbox-image{border:none;padding:2px 0 2px 0.5em;text-align:center}.mw-parser-output .ambox .mbox-imageright{border:none;padding:2px 0.5em 2px 0;text-align:center}.mw-parser-output .ambox .mbox-empty-cell{border:none;padding:0;width:1px}.mw-parser-output .ambox .mbox-image-div{width:52px}@media(min-width:720px){.mw-parser-output .ambox{margin:0 10%}}@media print{body.ns-0 .mw-parser-output .ambox{display:none!important}}


/* end https://en.wikipedia.org/ */
</style>
<p>Entity Types form the class of objects entities conform to, with the Entities being instances of the entity types. Entities represent individual objects that form a part of the problem being solved by the application and are indexed by a key. For example, converting the physical schema described above, we will have two entity types:
</p>
<ul><li><i>CustomerEntity</i>, which contains the customer's name from the <i>Customers</i> table, and the customer's address from the <i>Contacts</i> table.</li>
<li><i>OrderEntity</i>, which encapsulates the orders of a certain customer, retrieving it from the <i>Orders</i> table.</li></ul>
<p>The logical schema and its mapping with the physical schema is represented as an <b>Entity Data Model</b> (EDM), specified as an XML file. ADO.NET Entity Framework uses the EDM to actually perform the mapping letting the application work with the entities, while internally abstracting the use of ADO.NET constructs like <i>DataSet</i> and <i>RecordSet</i>. ADO.NET Entity Framework performs the <i><a href="SQL_join" class="mw-redirect" title="SQL join">joins</a></i> necessary to have entity reference information from multiple tables, or when a relationship is traversed. When an entity is updated, it traces back which table the information came from and issues SQL update statements to update the tables in which some data has been updated. ADO.NET Entity Framework uses eSQL, a derivative of SQL, to perform queries, set-theoretic operations, and updates on entities and their relationships. Queries in eSQL, if required, are then translated to the native SQL flavor of the underlying database.
</p><p>Entity types and entity sets just form the logical EDM schema, and can be exposed as anything. ADO.NET Entity Framework includes <i>Object Service</i> that presents these entities as <i><a href="Object_oriented_programming" class="mw-redirect" title="Object oriented programming">Objects</a></i> with the elements and relationships exposed as properties. Thus Entity objects are just front-end to the instances of the EDM entity types, which lets Object Oriented languages access and use them. Similarly, other front-ends can be created, which expose the entities via web services (e.g., <a href="WCF_Data_Services" title="WCF Data Services">WCF Data Services</a>) or XML that is used when entities are serialized for persistence storage or over-the-wire transfer.<sup id="cite_ref-34" class="reference"><a href="#cite_note-34"><span class="cite-bracket">[</span>34<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-heading mw-heading3"><h3 id="Entities">Entities</h3></div>
<p>Entities** are instances of <i>EntityType</i>s; they represent the individual instances of the objects (such as <i>customer</i>, <i>orders</i>) to which the information pertains. The identity of an entity is defined by the entity type it is an instance of; in that sense an entity type defines the class an entity belongs to and also defines what <i>properties</i> an entity will have. Properties describe some aspect of the entity by giving it a name and a type. The properties of an entity type in ADO.NET Entity Framework are fully typed, and are fully compatible with the type system used in a DBMS system, as well as the Common Type System of the .NET Framework. A property can be <i>SimpleType</i>, or <i>ComplexType</i>, and can be multi-valued as well. All <i>EntityType</i>s belong to some namespace, and have an <i>EntityKey</i> property that uniquely identifies each instance of the entity type. The different property types are distinguished as follows:
</p>
<ul><li><b>SimpleType</b>, corresponds to primitive data types such as <i>Integer</i>, <i>Characters</i> and <i>Floating Point</i> numbers.<sup id="cite_ref-SimpleTypes_35-0" class="reference"><a href="#cite_note-SimpleTypes-35"><span class="cite-bracket">[</span>35<span class="cite-bracket">]</span></a></sup></li>
<li><b>ComplexType</b>, is an aggregate of multiple properties of type <i>SimpleType</i>, or <i>ComplexType</i>. Unlike <i>EntityType</i>s, however, <i>ComplexTypes</i> cannot have an <i>EntityKey</i>. In Entity Framework v1 <i>ComplexTypes</i> cannot be inherited.<sup id="cite_ref-ComplexTypes_36-0" class="reference"><a href="#cite_note-ComplexTypes-36"><span class="cite-bracket">[</span>36<span class="cite-bracket">]</span></a></sup></li></ul>
<p>All entity instances are housed in EntityContainers, which are per-project containers for entities. Each project has one or more named EntityContainers, which can reference entities across multiple namespaces and entity types. Multiple instances of one entity type can be stored in collections called EntitySets. One entity type can have multiple EntitySets.
</p><p>EDM primitive types (simple types):<sup id="cite_ref-SimpleTypes_35-1" class="reference"><a href="#cite_note-SimpleTypes-35"><span class="cite-bracket">[</span>35<span class="cite-bracket">]</span></a></sup><sup id="cite_ref-ConceptualModelTypes_37-0" class="reference"><a href="#cite_note-ConceptualModelTypes-37"><span class="cite-bracket">[</span>37<span class="cite-bracket">]</span></a></sup>
</p>
<table class="wikitable">
<tbody><tr>
<th>EDM type
</th>
<th><a href="Common_Language_Runtime" title="Common Language Runtime">CLR</a> type mapping
</th></tr>
<tr>
<td><style data-mw-deduplicate="TemplateStyles:r886049734">
/* start https://en.wikipedia.org/ */


.mw-parser-output .monospaced{font-family:monospace,monospace}


/* end https://en.wikipedia.org/ */
</style><span class="monospaced">Edm.Binary</span>
</td>
<td><span class="monospaced">Byte[]</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Boolean</span>
</td>
<td><span class="monospaced">Boolean</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Byte</span>
</td>
<td><span class="monospaced">Byte</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.DateTime</span>
</td>
<td><span class="monospaced">DateTime</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.DateTimeOffset</span>
</td>
<td><span class="monospaced">DateTimeOffset</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Decimal</span>
</td>
<td><span class="monospaced">Decimal</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Double</span>
</td>
<td><span class="monospaced">Double</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Guid</span>
</td>
<td><span class="monospaced">Guid</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Int16</span>
</td>
<td><span class="monospaced">Int16</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Int32</span>
</td>
<td><span class="monospaced">Int32</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Int64</span>
</td>
<td><span class="monospaced">Int64</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.SByte</span>
</td>
<td><span class="monospaced">SByte</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Single</span>
</td>
<td><span class="monospaced">Single</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.String</span>
</td>
<td><span class="monospaced">String</span>
</td></tr>
<tr>
<td><span class="monospaced">Edm.Time</span>
</td>
<td><span class="monospaced">TimeSpan</span>
</td></tr></tbody></table>
<div class="mw-heading mw-heading3"><h3 id="Relationships">Relationships</h3></div>
<p>Any two entity types can be related, by either an <i>Association</i> relation or a <i>Containment</i> relation. For example, a shipment <i>is billed</i> to a customer is an association whereas an order <i>contains</i> order details is a containment relation. A containment relation can also be used to model inheritance between entities. The relation between two entity types is specified by a <i>Relationship Type</i>, instances of which, called <i>Relationships</i>, relate entity instances. In future releases, other kinds of relationship types such as <i>Composition</i>, or <i>Identification</i>, may be introduced.
</p><p>Relationship types are characterized by their degree (arity) or the count of entity types they relate and their multiplicity. However, in the initial release of ADO.NET Entity Framework, relationships are limited to a binary (of degree two) bi-directional relationship. Multiplicity defines how many entity instances can be related together. Based on multiplicity, relationships can be either one-to-one, one-to-many, or many-to-many. Relationships between entities are named; the name is called a Role. It defines the purpose of the relationship.
</p><p>A relationship type can also have an <i>Operation</i> or <i>Action</i> associated with it, which allows some action to be performed on an entity in the event of an action being performed on a related entity. A relationship can be specified to take an <i>Action</i> when some <i>Operation</i> is done on a related entity. For example, on deleting an entity that forms the part of a relation (the <i>OnDelete</i> operation) the actions that can be taken are:<sup id="cite_ref-OnDelete_38-0" class="reference"><a href="#cite_note-OnDelete-38"><span class="cite-bracket">[</span>38<span class="cite-bracket">]</span></a></sup>
</p>
<ul><li><b>Cascade</b>, which instructs to delete the relationship instance and all associated entity instances.</li>
<li><b>None</b>.</li></ul>
<p>For association relationships, which can have different semantics at either ends, different actions can be specified for either end.
</p>
<div class="mw-heading mw-heading3"><h3 id="Schema_definition_language">Schema definition language</h3></div>
<p>ADO.NET Entity Framework uses an XML based Data Definition Language called <i>Schema Definition Language</i> (SDL) to define the EDM Schema. The SDL defines the SimpleTypes similar to the <a href="Common_Type_System" title="Common Type System">CTS</a> primitive types, including <i>String</i>, <i>Int32</i>, <i>Double</i>, <i>Decimal</i>, <i>Guid</i>, and <i>DateTime</i>, among others. An <i>Enumeration</i>, which defines a map of primitive values and names, is also considered a simple type. Enumerations are supported from framework version 5.0 onwards only. ComplexTypes are created from an aggregation of other types. A collection of properties of these types define an Entity Type. This definition can be written in EBNF grammar as:
</p>
<div class="mw-highlight mw-highlight-lang-ebnf mw-content-ltr" dir="ltr"><pre><span class="k">EntityType </span><span class="err">::</span><span class="o">=</span>
<span class="k">ENTITYTYPE entityTypeName </span><span class="p">[</span><span class="k">BASE entityTypeName</span><span class="p">]</span>
<span class="p">[</span><span class="k">ABSTRACT true</span><span class="p">|</span><span class="k">false</span><span class="p">]</span> <span class="k">KEY propertyName </span><span class="p">[,</span> <span class="k">propertyName</span><span class="p">]</span><span class="err">*</span>
<span class="p">{(</span><span class="k">propertyName PropertyType </span><span class="p">[</span><span class="k">PropertyFacet</span><span class="p">]</span><span class="err">*</span><span class="p">)</span> <span class="err">+</span><span class="p">}</span>

<span class="k">PropertyType </span><span class="err">::=</span> <span class="p">(</span>
<span class="p">(</span><span class="k">PrimitiveType </span><span class="p">[</span><span class="k">PrimitiveTypeFacets</span><span class="p">]</span><span class="err">*</span><span class="p">)</span>
<span class="p">|</span> <span class="p">(</span><span class="k">complexTypeName</span><span class="p">)</span>
<span class="p">|</span> <span class="k">RowType</span>

<span class="k">PropertyFacet </span><span class="err">::=</span> <span class="p">(</span>
<span class="p">[</span><span class="k">NULLABLE true </span><span class="p">|</span> <span class="k">false</span><span class="p">]</span>
<span class="p">|</span> <span class="p">[</span><span class="k">DEFAULT defaultVal</span><span class="p">]</span>
<span class="p">|</span> <span class="p">[</span><span class="k">MULTIPLICITY </span><span class="p">[</span><span class="err">1</span><span class="p">|</span><span class="err">*</span><span class="p">]]</span>
<span class="p">)</span>

<span class="k">PropertyTypeFacet </span><span class="err">::=</span>
<span class="k">MAXLENGTH </span><span class="p">|</span> <span class="k">PRECISION </span><span class="p">|</span> <span class="k">SCALE </span>
<span class="p">|</span> <span class="k">UNICODE </span><span class="p">|</span> <span class="k">FIXEDLENGTH </span><span class="p">|</span> <span class="k">COLLATION</span>
<span class="p">|</span> <span class="k">DATETIMEKIND </span><span class="p">|</span> <span class="k">PRESERVESECONDS</span>

<span class="k">PrimitiveType </span><span class="err">::=</span>
<span class="k">BINARY </span><span class="p">|</span> <span class="k">STRING </span><span class="p">|</span> <span class="k">BOOLEAN</span>
<span class="p">|</span> <span class="k">SINGLE </span><span class="p">|</span> <span class="k">DOUBLE </span><span class="p">|</span> <span class="k">DECIMAL </span><span class="p">|</span> <span class="k">GUID</span>
<span class="p">|</span> <span class="k">BYTE </span><span class="p">|</span> <span class="k">SBYTE </span><span class="p">|</span> <span class="k">INT16 </span><span class="p">|</span> <span class="k">INT32 </span><span class="p">|</span> <span class="k">INT64</span>
<span class="p">|</span> <span class="k">DATETIME </span><span class="p">|</span> <span class="k">DATETIMEOFFSET </span><span class="p">|</span> <span class="k">TIME</span>
<span class="p">)</span>
</pre></div>
<p><i>Facets</i> are used to describe metadata of a property, such as whether it is nullable or has a default value, as also the cardinality of the property, i.e., whether the property is single valued or multi valued. A multiplicity of “1” denotes a single valued property; a “*” means it is a multi-valued property. As an example, an entity can be denoted in SDL as:<sup id="cite_ref-Facets_39-0" class="reference"><a href="#cite_note-Facets-39"><span class="cite-bracket">[</span>39<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-highlight mw-highlight-lang-xml mw-content-ltr" dir="ltr"><pre><span class="nt">&lt;ComplexType</span><span class="w"> </span><span class="na">Name=</span><span class="s">"Addr"</span><span class="nt">&gt;</span>
<span class="w"> </span><span class="nt">&lt;Property</span><span class="w"> </span><span class="na">Name=</span><span class="s">"Street"</span><span class="w"> </span><span class="na">Type=</span><span class="s">"String"</span><span class="w"> </span><span class="na">Nullable=</span><span class="s">"false"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="w"> </span><span class="nt">&lt;Property</span><span class="w"> </span><span class="na">Name=</span><span class="s">"City"</span><span class="w"> </span><span class="na">Type=</span><span class="s">"String"</span><span class="w"> </span><span class="na">Nullable=</span><span class="s">"false"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="w"> </span><span class="nt">&lt;Property</span><span class="w"> </span><span class="na">Name=</span><span class="s">"Country"</span><span class="w"> </span><span class="na">Type=</span><span class="s">"String"</span><span class="w"> </span><span class="na">Nullable=</span><span class="s">"false"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="w"> </span><span class="nt">&lt;Property</span><span class="w"> </span><span class="na">Name=</span><span class="s">"PostalCode"</span><span class="w"> </span><span class="na">Type=</span><span class="s">"Int32"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="nt">&lt;/ComplexType&gt;</span>
<span class="nt">&lt;EntityType</span><span class="w"> </span><span class="na">Name=</span><span class="s">"Customer"</span><span class="nt">&gt;</span>
<span class="w"> </span><span class="nt">&lt;Key&gt;</span>
<span class="w"> </span><span class="nt">&lt;PropertyRef</span><span class="w"> </span><span class="na">Name=</span><span class="s">"Email"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="w"> </span><span class="nt">&lt;/Key&gt;</span>
<span class="w"> </span><span class="nt">&lt;Property</span><span class="w"> </span><span class="na">Name=</span><span class="s">"Name"</span><span class="w"> </span><span class="na">Type=</span><span class="s">"String"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="w"> </span><span class="nt">&lt;Property</span><span class="w"> </span><span class="na">Name=</span><span class="s">"Email"</span><span class="w"> </span><span class="na">Type=</span><span class="s">"String"</span><span class="w"> </span><span class="na">Nullable=</span><span class="s">"false"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="w"> </span><span class="nt">&lt;Property</span><span class="w"> </span><span class="na">Name=</span><span class="s">"Address"</span><span class="w"> </span><span class="na">Type=</span><span class="s">"Addr"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="nt">&lt;/EntityType&gt;</span>
</pre></div>
<p>A relationship type is defined as specifying the end points and their multiplicities. For example, a one-to-many relationship between <i>Customer</i> and <i>Orders</i> can be defined as
</p>
<div class="mw-highlight mw-highlight-lang-xml mw-content-ltr" dir="ltr"><pre><span class="nt">&lt;Association</span><span class="w"> </span><span class="na">Name=</span><span class="s">"CustomerAndOrders"</span><span class="nt">&gt;</span>
<span class="w"> </span><span class="nt">&lt;End</span><span class="w"> </span><span class="na">Type=</span><span class="s">"Customer"</span><span class="w"> </span><span class="na">Multiplicity=</span><span class="s">"1"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="w"> </span><span class="nt">&lt;End</span><span class="w"> </span><span class="na">Type=</span><span class="s">"Orders"</span><span class="w"> </span><span class="na">Multiplicity=</span><span class="s">"*"</span><span class="nt">&gt;</span>
<span class="w"> </span><span class="nt">&lt;OnDelete</span><span class="w"> </span><span class="na">Action=</span><span class="s">"Cascade"</span><span class="w"> </span><span class="nt">/&gt;</span>
<span class="w"> </span><span class="nt">&lt;/End&gt;</span>
<span class="nt">&lt;/Association&gt;</span>
</pre></div>
<div class="mw-heading mw-heading2"><h2 id="Querying_data">Querying data</h2></div>
<div class="mw-heading mw-heading3"><h3 id="Entity_SQL">Entity SQL</h3></div>
<p>ADO.NET Entity Framework uses a variant of the <a href="SQL" title="SQL">Structured Query Language</a>, named <i>Entity SQL</i>, which is aimed at writing declarative queries and updates over entities and entity relationships – at the conceptual level. It differs from SQL in that it does not have explicit constructs for <i>joins</i> because the EDM is designed to abstract partitioning data across tables.
</p><p>Querying against the conceptual model is facilitated by <i>EntityClient</i> classes, which accepts an Entity SQL query. The query pipeline parses the Entity SQL query into a command tree, segregating the query across multiple tables, which is handed over to the EntityClient provider. Like ADO.NET data providers, an EntityClient provider is also initialized using a <i>Connection</i> object, which in addition to the usual parameters of data store and authentication info, requires the SDL schema and the mapping information. The EntityClient provider in turn then turns the Entity SQL command tree into an SQL query in the native flavor of the database. The execution of the query then returns an Entity SQL ResultSet, which is not limited to a tabular structure, unlike ADO.NET ResultSets.
</p><p>Entity SQL enhances SQL by adding intrinsic support for:
</p>
<ul><li><b>Types</b>, as ADO.NET entities are fully typed.</li>
<li><b>EntitySets</b>, which are treated as collections of entities.</li>
<li><b>Composability</b>, which removes restrictions on where subqueries can be used.</li></ul>
<div class="mw-heading mw-heading4"><h4 id="Entity_SQL_canonical_functions">Entity SQL canonical functions</h4></div>
<p>Canonical functions are supported by all Entity Framework compliant data providers. They can be used in an Entity SQL query. Also, most of the extension methods in LINQ to Entities are translated to canonical functions. They are independent of any specific database. When ADO.NET data provider receives a function, it translates it to the desired SQL statement.<sup id="cite_ref-MsdnCanonicalFunctions_40-0" class="reference"><a href="#cite_note-MsdnCanonicalFunctions-40"><span class="cite-bracket">[</span>40<span class="cite-bracket">]</span></a></sup>
</p><p>But not all DBMSs have equivalent functionality and a set of standard embedded functions. There are also differences in the accuracy of calculations. Therefore, not all canonical functions are supported for all databases, and not all canonical functions return the same results.
</p>
<table class="wikitable">
<tbody><tr>
<th>Group
</th>
<th>Canonical functions<sup id="cite_ref-MsdnCanonicalFunctions_40-1" class="reference"><a href="#cite_note-MsdnCanonicalFunctions-40"><span class="cite-bracket">[</span>40<span class="cite-bracket">]</span></a></sup>
</th></tr>
<tr>
<td width="15%">Aggregate functions
</td>
<td><span class="monospaced">Avg, BigCount, Count, Max, Min, StDev, StDevP, Sum, Var, VarP</span>
</td></tr>
<tr>
<td>Math functions
</td>
<td><span class="monospaced">Abs, Ceiling, Floor, Power, Round, Truncate</span>
</td></tr>
<tr>
<td>String functions
</td>
<td><span class="monospaced">Concat, Contains, EndsWith, IndexOf, Left, Length, LTrim, Replace, Reverse, Right, RTrim, Substring, StartsWith, ToLower, ToUpper, Trim</span>
</td></tr>
<tr>
<td>Date and Time functions
</td>
<td><span class="monospaced">AddMicroseconds, AddMilliseconds, AddSeconds, AddMinutes, AddHours, AddNanoseconds, AddDays, AddYears, CreateDateTime, AddMonths, CreateDateTimeOffset, CreateTime, CurrentDateTime, CurrentDateTimeOffset, CurrentUtcDateTime, Day, DayOfYear, DiffNanoseconds, DiffMilliseconds, DiffMicroseconds, DiffSeconds, DiffMinutes, DiffHours, DiffDays, DiffMonths, DiffYears, GetTotalOffsetMinutes, Hour, Millisecond, Minute, Month, Second, TruncateTime, Year</span>
</td></tr>
<tr>
<td>Bitwise functions
</td>
<td><span class="monospaced">BitWiseAnd, BitWiseNot, BitWiseOr, BitWiseXor</span>
</td></tr>
<tr>
<td>Other functions
</td>
<td><span class="monospaced">NewGuid</span>
</td></tr></tbody></table>
<div class="mw-heading mw-heading3"><h3 id="LINQ_to_Entities">LINQ to Entities</h3></div>

<p>The LINQ to Entities provider allows <a href="LINQ" class="mw-redirect" title="LINQ">LINQ</a> to be used to query various <a href="RDBMS" class="mw-redirect" title="RDBMS">RDBMS</a> data sources. Several database server specific providers with Entity Framework support are available.
</p>
<div class="mw-heading mw-heading3"><h3 id="Native_SQL">Native SQL</h3></div>
<p>In the Entity Framework v4 new methods <i>ExecuteStoreQuery()</i> and <i>ExecuteStoreCommand()</i> were added to the class ObjectContext.
</p>
<div class="mw-heading mw-heading3"><h3 id="Visualizers">Visualizers</h3></div>
<p>Visual Studio has a feature called Visualizer. A LINQ query written in Visual Studio can be viewed as Native SQL using a Visualizer during debug session. A Visualizer for LINQ to Entities (Object Query) targeting all RDBMS is available in the Visual Studio Marketplace.<sup id="cite_ref-41" class="reference"><a href="#cite_note-41"><span class="cite-bracket">[</span>41<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-heading mw-heading2"><h2 id="Performance_Profiling">Performance Profiling</h2></div>
<p>Various profilers are commercially available to troubleshoot performance issues using Entity Framework, both for EF and EF Core variants.
</p>
<div class="mw-heading mw-heading2"><h2 id="Tools_and_Extensions_-_Entity_Framework_Core">Tools and Extensions - Entity Framework Core</h2></div>
<p>Entity Framework Core Tools and Extensions are available to enhance the performance of Entity Framework Core.<sup id="cite_ref-42" class="reference"><a href="#cite_note-42"><span class="cite-bracket">[</span>42<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-heading mw-heading2"><h2 id="Tools_and_Extensions_-_Entity_Framework_EF6">Tools and Extensions - Entity Framework EF6</h2></div>
<p>Entity Framework Tools and Extensions are available to enhance the performance of Entity Framework.<sup id="cite_ref-43" class="reference"><a href="#cite_note-43"><span class="cite-bracket">[</span>43<span class="cite-bracket">]</span></a></sup>
</p>
<div class="mw-heading mw-heading2"><h2 id="See_also">See also</h2></div>
<style data-mw-deduplicate="TemplateStyles:r1266661725">
/* start https://en.wikipedia.org/ */


.mw-parser-output .portalbox{padding:0;margin:0.5em 0;display:table;box-sizing:border-box;max-width:175px;list-style:none}.mw-parser-output .portalborder{border:1px solid var(--border-color-base,#a2a9b1);padding:0.1em;background:var(--background-color-neutral-subtle,#f8f9fa)}.mw-parser-output .portalbox-entry{display:table-row;font-size:85%;line-height:110%;height:1.9em;font-style:italic;font-weight:bold}.mw-parser-output .portalbox-image{display:table-cell;padding:0.2em;vertical-align:middle;text-align:center}.mw-parser-output .portalbox-link{display:table-cell;padding:0.2em 0.2em 0.2em 0.3em;vertical-align:middle}@media(min-width:720px){.mw-parser-output .portalleft{margin:0.5em 1em 0.5em 0}.mw-parser-output .portalright{clear:right;float:right;margin:0.5em 0 0.5em 1em}}


/* end https://en.wikipedia.org/ */
</style>
<ul><li><a href="List_of_object%E2%80%93relational_mapping_software" title="List of object–relational mapping software">List of object–relational mapping software</a></li>
<li><a href="LINQ_to_SQL" class="mw-redirect" title="LINQ to SQL">LINQ to SQL</a></li>
<li><a href=".NET_Persistence_API" title=".NET Persistence API">.NET Persistence API (NPA)</a></li>
<li><a rel="nofollow" class="external text" href="https://www.llblgen.com/">LLBLGEN Pro</a></li></ul>
<div class="mw-heading mw-heading2"><h2 id="References">References</h2></div>
<style data-mw-deduplicate="TemplateStyles:r1239543626">
/* start https://en.wikipedia.org/ */


.mw-parser-output .reflist{margin-bottom:0.5em;list-style-type:decimal}@media screen{.mw-parser-output .reflist{font-size:90%}}.mw-parser-output .reflist .references{font-size:100%;margin-bottom:0;list-style-type:inherit}.mw-parser-output .reflist-columns-2{column-width:30em}.mw-parser-output .reflist-columns-3{column-width:25em}.mw-parser-output .reflist-columns{margin-top:0.3em}.mw-parser-output .reflist-columns ol{margin-top:0}.mw-parser-output .reflist-columns li{page-break-inside:avoid;break-inside:avoid-column}.mw-parser-output .reflist-upper-alpha{list-style-type:upper-alpha}.mw-parser-output .reflist-upper-roman{list-style-type:upper-roman}.mw-parser-output .reflist-lower-alpha{list-style-type:lower-alpha}.mw-parser-output .reflist-lower-greek{list-style-type:lower-greek}.mw-parser-output .reflist-lower-roman{list-style-type:lower-roman}


/* end https://en.wikipedia.org/ */
</style><div class="reflist">
<div class="mw-references-wrap mw-references-columns"><ol class="references">
<li id="cite_note-CoreVer-1"><span class="mw-cite-backlink"><b><a href="#cite_ref-CoreVer_1-0">^</a></b></span> <span class="reference-text"><style data-mw-deduplicate="TemplateStyles:r1238218222">
/* start https://en.wikipedia.org/ */


.mw-parser-output cite.citation{font-style:inherit;word-wrap:break-word}.mw-parser-output .citation q{quotes:"\"""\"""'""'"}.mw-parser-output .citation:target{background-color:rgba(0,127,255,0.133)}.mw-parser-output .id-lock-free.id-lock-free a{background:url("./mw/Lock-green.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-limited.id-lock-limited a,.mw-parser-output .id-lock-registration.id-lock-registration a{background:url("./mw/Lock-gray-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .id-lock-subscription.id-lock-subscription a{background:url("./mw/Lock-red-alt-2.svg")right 0.1em center/9px no-repeat}.mw-parser-output .cs1-ws-icon a{background:url("./mw/Wikisource-logo.svg")right 0.1em center/12px no-repeat}body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-free a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-limited a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-registration a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .id-lock-subscription a,body:not(.skin-timeless):not(.skin-minerva) .mw-parser-output .cs1-ws-icon a{background-size:contain;padding:0 1em 0 0}.mw-parser-output .cs1-code{color:inherit;background:inherit;border:none;padding:inherit}.mw-parser-output .cs1-hidden-error{display:none;color:var(--color-error,#d33)}.mw-parser-output .cs1-visible-error{color:var(--color-error,#d33)}.mw-parser-output .cs1-maint{display:none;color:#085;margin-left:0.3em}.mw-parser-output .cs1-kern-left{padding-left:0.2em}.mw-parser-output .cs1-kern-right{padding-right:0.2em}.mw-parser-output .citation .mw-selflink{font-weight:inherit}@media screen{.mw-parser-output .cs1-format{font-size:95%}html.skin-theme-clientpref-night .mw-parser-output .cs1-maint{color:#18911f}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .cs1-maint{color:#18911f}}


/* end https://en.wikipedia.org/ */
</style><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://github.com/dotnet/efcore/releases">"Releases · dotnet/efcore · GitHub"</a>. <i><a href="GitHub" title="GitHub">GitHub</a></i>.</cite></span>
</li>
<li id="cite_note-2"><span class="mw-cite-backlink"><b><a href="#cite_ref-2">^</a></b></span> <span class="reference-text"><cite id="CITEREFKrill2012" class="citation news cs1">Krill, Paul (20 July 2012). <a rel="nofollow" class="external text" href="http://www.infoworld.com/d/application-development/microsoft-open-sources-entity-framework-198213">"Microsoft open-sources Entity Framework"</a>. <i>InfoWorld</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2012-07-24</span></span>.</cite></span>
</li>
<li id="cite_note-3"><span class="mw-cite-backlink"><b><a href="#cite_ref-3">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers2022" class="citation web cs1">ajcvickers (9 March 2022). <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/efcore-and-ef6/support">"Entity Framework Support Policies"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-4"><span class="mw-cite-backlink"><b><a href="#cite_ref-4">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers" class="citation web cs1">ajcvickers. <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/efcore-and-ef6/">"Compare EF6 and EF Core"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-5"><span class="mw-cite-backlink"><b><a href="#cite_ref-5">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://github.com/dotnet/efcore/releases">"Releases · dotnet/efcore"</a>. <i>github.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2025-04-28</span></span>.</cite></span>
</li>
<li id="cite_note-6"><span class="mw-cite-backlink"><b><a href="#cite_ref-6">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://www.agiledata.org/essays/impedanceMismatch.html">"The Object-Relational Impedance Mismatch"</a>. <i>AgileData.org</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-7"><span class="mw-cite-backlink"><b><a href="#cite_ref-7">^</a></b></span> <span class="reference-text"><cite id="CITEREFmcleblanc2021" class="citation web cs1">mcleblanc (15 September 2021). <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/ef/overview">"Entity Framework Overview - ADO.NET"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-vonc-8"><span class="mw-cite-backlink"><b><a href="#cite_ref-vonc_8-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://efvote.wufoo.com/reports/entity-framework-vote-of-no-confidence-signatories/#public">"Entity Framework Vote of No Confidence Signatories | Wufoo"</a>. <i>efvote.wufoo.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-verfour-9"><span class="mw-cite-backlink"><b><a href="#cite_ref-verfour_9-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20100120170901/http://blogs.msdn.com/adonet/archive/2009/05/11/update-on-the-entity-framework-in-net-4-and-visual-studio-2010.aspx">"Update on the Entity Framework in .NET 4 and Visual Studio 2010"</a>. ADO.NET team blog. May 11, 2009. Archived from <a rel="nofollow" class="external text" href="http://blogs.msdn.com/adonet/archive/2009/05/11/update-on-the-entity-framework-in-net-4-and-visual-studio-2010.aspx">the original</a> on January 20, 2010<span class="reference-accessdate">. Retrieved <span class="nowrap">November 1,</span> 2011</span>.</cite></span>
</li>
<li id="cite_note-verfourthreeone-10"><span class="mw-cite-backlink"><b><a href="#cite_ref-verfourthreeone_10-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20120325142128/http://blogs.msdn.com/b/adonet/archive/2012/02/29/ef4-3-1-and-ef5-beta-1-available-on-nuget.aspx">"EF4.3.1 and EF5 Beta 1 Available on NuGet"</a>. ADO.NET team blog. February 29, 2012. Archived from <a rel="nofollow" class="external text" href="http://blogs.msdn.com/b/adonet/archive/2012/02/29/ef4-3-1-and-ef5-beta-1-available-on-nuget.aspx">the original</a> on March 25, 2012<span class="reference-accessdate">. Retrieved <span class="nowrap">March 27,</span> 2012</span>.</cite></span>
</li>
<li id="cite_note-verfive-11"><span class="mw-cite-backlink"><b><a href="#cite_ref-verfive_11-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20170907043317/http://entityframework.codeplex.com/releases/view/86738">"EF5 Available on CodePlex"</a>. August 11, 2012. Archived from <a rel="nofollow" class="external text" href="https://entityframework.codeplex.com/releases/view/86738">the original</a> on September 7, 2017<span class="reference-accessdate">. Retrieved <span class="nowrap">March 20,</span> 2014</span>.</cite></span>
</li>
<li id="cite_note-versionsix-12"><span class="mw-cite-backlink"><b><a href="#cite_ref-versionsix_12-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20140330034136/http://blogs.msdn.com/b/adonet/archive/2013/10/17/ef6-rtm-available.aspx">"EF6 RTM Available"</a>. October 17, 2013. Archived from <a rel="nofollow" class="external text" href="http://blogs.msdn.com/b/adonet/archive/2013/10/17/ef6-rtm-available.aspx">the original</a> on 2014-03-30.</cite></span>
</li>
<li id="cite_note-13"><span class="mw-cite-backlink"><b><a href="#cite_ref-13">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://github.com/aspnet/EntityFramework6">"Entity Framework - Home"</a>. <i><a href="GitHub" title="GitHub">GitHub</a></i>. September 14, 2016.</cite></span>
</li>
<li id="cite_note-versiximprovements-14"><span class="mw-cite-backlink"><b><a href="#cite_ref-versiximprovements_14-0">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers2020" class="citation web cs1">ajcvickers (14 October 2020). <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/ef6/what-is-new/">"What's new - EF6"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-versionseven-15"><span class="mw-cite-backlink">^ <a href="#cite_ref-versionseven_15-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-versionseven_15-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://web.archive.org/web/20150929124551/http://blogs.msdn.com/b/adonet/archive/2014/05/19/ef7-new-platforms-new-data-stores.aspx">"EF7 - New Platforms, New Data Stores"</a>. May 19, 2014. Archived from <a rel="nofollow" class="external text" href="http://blogs.msdn.com/b/adonet/archive/2014/05/19/ef7-new-platforms-new-data-stores.aspx">the original</a> on 2015-09-29.</cite></span>
</li>
<li id="cite_note-efcore-10-available-16"><span class="mw-cite-backlink"><b><a href="#cite_ref-efcore-10-available_16-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://blogs.msdn.microsoft.com/dotnet/2016/06/27/entity-framework-core-1-0-0-available/">"Entity Framework Core 1.0.0 Available"</a>. 27 June 2016.</cite></span>
</li>
<li id="cite_note-17"><span class="mw-cite-backlink"><b><a href="#cite_ref-17">^</a></b></span> <span class="reference-text"><cite id="CITEREFHanselman" class="citation web cs1">Hanselman, Scott. <a rel="nofollow" class="external text" href="http://www.hanselman.com/blog/ASPNET5IsDeadIntroducingASPNETCore10AndNETCore10.aspx">"ASP.NET 5 is dead - Introducing ASP.NET Core 1.0 and .NET Core 1.0 - Scott Hanselman"</a>. <i>www.hanselman.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2016-07-11</span></span>.</cite></span>
</li>
<li id="cite_note-18"><span class="mw-cite-backlink"><b><a href="#cite_ref-18">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://blogs.msdn.microsoft.com/dotnet/2017/08/14/announcing-net-core-2-0/">"Announcing .NET Core 2.0"</a>. .NET Blog. 14 August 2017.</cite></span>
</li>
<li id="cite_note-19"><span class="mw-cite-backlink"><b><a href="#cite_ref-19">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://devblogs.microsoft.com/dotnet/announcing-net-core-3-0/">"Announcing .NET Core 3.0"</a>. .NET Blog. 23 September 2019.</cite></span>
</li>
<li id="cite_note-EF_Core_releases_and_planning-20"><span class="mw-cite-backlink">^ <a href="#cite_ref-EF_Core_releases_and_planning_20-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-EF_Core_releases_and_planning_20-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite id="CITEREFajcvickers" class="citation web cs1">ajcvickers. <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-5.0/plan">"Plan for Entity Framework Core 5.0"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-nuget.org-21"><span class="mw-cite-backlink">^ <a href="#cite_ref-nuget.org_21-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-nuget.org_21-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://nuget.org/packages/Microsoft.EntityFrameworkCore/">"Microsoft.EntityFrameworkCore 5.0.0"</a>. <i>nuget.org</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-22"><span class="mw-cite-backlink"><b><a href="#cite_ref-22">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/">"Entity Framework Core Releases and Planning"</a>. December 2023.</cite></span>
</li>
<li id="cite_note-23"><span class="mw-cite-backlink"><b><a href="#cite_ref-23">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers" class="citation web cs1">ajcvickers. <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-6.0/plan">"Plan for Entity Framework Core 6.0"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-24"><span class="mw-cite-backlink"><b><a href="#cite_ref-24">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://nuget.org/packages/Microsoft.EntityFrameworkCore/">"Microsoft.EntityFrameworkCore 6.0.0"</a>. <i>nuget.org</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-25"><span class="mw-cite-backlink"><b><a href="#cite_ref-25">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers" class="citation web cs1">ajcvickers. <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/">"EF Core releases and planning"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-26"><span class="mw-cite-backlink"><b><a href="#cite_ref-26">^</a></b></span> <span class="reference-text"><cite id="CITEREFRoth2022" class="citation web cs1">Roth, Daniel (2022-11-08). <a rel="nofollow" class="external text" href="https://devblogs.microsoft.com/dotnet/announcing-asp-net-core-in-dotnet-7/">"Announcing ASP.NET Core in .NET 7"</a>. <i>.NET Blog</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-27"><span class="mw-cite-backlink"><b><a href="#cite_ref-27">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers" class="citation web cs1">ajcvickers. <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-7.0/whatsnew">"What's New in EF Core 7.0"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-28"><span class="mw-cite-backlink"><b><a href="#cite_ref-28">^</a></b></span> <span class="reference-text"><cite id="CITEREFArthur2023" class="citation web cs1">Arthur, Vickers (2023-11-14). <a rel="nofollow" class="external text" href="https://devblogs.microsoft.com/dotnet/announcing-ef8/">"Entity Framework Core 8 (EF8) is available today"</a>. <i>.NET Blog</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2023-11-14</span></span>.</cite></span>
</li>
<li id="cite_note-29"><span class="mw-cite-backlink"><b><a href="#cite_ref-29">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers2023" class="citation web cs1">ajcvickers (14 November 2023). <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/what-is-new/ef-core-8.0/whatsnew">"What's New in EF Core 8"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2023-11-14</span></span>.</cite></span>
</li>
<li id="cite_note-entitydatamodel-30"><span class="mw-cite-backlink"><b><a href="#cite_ref-entitydatamodel_30-0">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/ee382825.aspx">"Entity Data Model"</a>. MSDN, Microsoft. August 2, 2012<span class="reference-accessdate">. Retrieved <span class="nowrap">August 15,</span> 2013</span>.</cite></span>
</li>
<li id="cite_note-CsdlMslSsdl-31"><span class="mw-cite-backlink"><b><a href="#cite_ref-CsdlMslSsdl_31-0">^</a></b></span> <span class="reference-text"><cite class="citation cs2"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/bb399604.aspx"><i>CSDL, SSDL, and MSL Specifications</i></a>, <a href="MSDN" class="mw-redirect" title="MSDN">MSDN</a>, <a rel="nofollow" class="external text" href="https://web.archive.org/web/20101108063931/http://msdn.microsoft.com/en-us/library/bb399604.aspx">archived</a> from the original on 2010-11-08<span class="reference-accessdate">, retrieved <span class="nowrap">2010-12-06</span></span></cite></span>
</li>
<li id="cite_note-32"><span class="mw-cite-backlink"><b><a href="#cite_ref-32">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers2022" class="citation web cs1">ajcvickers (2022-03-09). <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/efcore-and-ef6/porting/port-edmx">"Porting from EF6 to EF Core - Porting an EDMX-Based Model - EF"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2024-06-07</span></span>.</cite></span>
</li>
<li id="cite_note-EdmWizard-33"><span class="mw-cite-backlink"><b><a href="#cite_ref-EdmWizard_33-0">^</a></b></span> <span class="reference-text"><cite class="citation cs2"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/bb399247(VS.100).aspx"><i>Entity Data Model Wizard</i></a>, <a href="MSDN" class="mw-redirect" title="MSDN">MSDN</a><span class="reference-accessdate">, retrieved <span class="nowrap">2010-12-06</span></span></cite></span>
</li>
<li id="cite_note-34"><span class="mw-cite-backlink"><b><a href="#cite_ref-34">^</a></b></span> <span class="reference-text"><cite id="CITEREFKogent_Solutions_Inc.2009" class="citation cs2">Kogent Solutions Inc. (2009), <i>ASP.NET 3.5 Black Book</i>, Dreamtech Press, <a href="ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a>&nbsp;<bdi>978-81-7722-831-1</bdi></cite></span>
</li>
<li id="cite_note-SimpleTypes-35"><span class="mw-cite-backlink">^ <a href="#cite_ref-SimpleTypes_35-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-SimpleTypes_35-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite class="citation cs2"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/bb399213(VS.100).aspx"><i>Simple Types (EDM)</i></a>, <a href="MSDN" class="mw-redirect" title="MSDN">MSDN</a><span class="reference-accessdate">, retrieved <span class="nowrap">2010-12-06</span></span></cite></span>
</li>
<li id="cite_note-ComplexTypes-36"><span class="mw-cite-backlink"><b><a href="#cite_ref-ComplexTypes_36-0">^</a></b></span> <span class="reference-text"><cite class="citation cs2"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/cc716799(VS.100).aspx"><i>ComplexType Element (CSDL)</i></a>, <a href="MSDN" class="mw-redirect" title="MSDN">MSDN</a><span class="reference-accessdate">, retrieved <span class="nowrap">2010-12-06</span></span></cite></span>
</li>
<li id="cite_note-ConceptualModelTypes-37"><span class="mw-cite-backlink"><b><a href="#cite_ref-ConceptualModelTypes_37-0">^</a></b></span> <span class="reference-text"><cite class="citation cs2"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/bb399548(VS.100).aspx"><i>Conceptual Model Types</i></a>, <a href="MSDN" class="mw-redirect" title="MSDN">MSDN</a><span class="reference-accessdate">, retrieved <span class="nowrap">2010-12-06</span></span></cite></span>
</li>
<li id="cite_note-OnDelete-38"><span class="mw-cite-backlink"><b><a href="#cite_ref-OnDelete_38-0">^</a></b></span> <span class="reference-text"><cite class="citation cs2"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/cc716734(VS.100).aspx"><i>OnDelete Element (CSDL)</i></a>, <a href="MSDN" class="mw-redirect" title="MSDN">MSDN</a><span class="reference-accessdate">, retrieved <span class="nowrap">2010-12-06</span></span></cite></span>
</li>
<li id="cite_note-Facets-39"><span class="mw-cite-backlink"><b><a href="#cite_ref-Facets_39-0">^</a></b></span> <span class="reference-text"><cite class="citation cs2"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/cc716737(VS.100).aspx"><i>Facets (CSDL)</i></a>, <a href="MSDN" class="mw-redirect" title="MSDN">MSDN</a><span class="reference-accessdate">, retrieved <span class="nowrap">2010-12-06</span></span></cite></span>
</li>
<li id="cite_note-MsdnCanonicalFunctions-40"><span class="mw-cite-backlink">^ <a href="#cite_ref-MsdnCanonicalFunctions_40-0"><sup><i><b>a</b></i></sup></a> <a href="#cite_ref-MsdnCanonicalFunctions_40-1"><sup><i><b>b</b></i></sup></a></span> <span class="reference-text"><cite class="citation cs2"><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/library/bb738626(VS.100).aspx"><i>Canonical Functions (Entity SQL)</i></a>, <a href="MSDN" class="mw-redirect" title="MSDN">MSDN</a><span class="reference-accessdate">, retrieved <span class="nowrap">2010-03-29</span></span></cite></span>
</li>
<li id="cite_note-41"><span class="mw-cite-backlink"><b><a href="#cite_ref-41">^</a></b></span> <span class="reference-text"><cite class="citation web cs1"><a rel="nofollow" class="external text" href="https://marketplace.visualstudio.com/items?itemName=RRV.LinqtoEntityqueryvisualizer">"Linq to Entity query visualizer - Visual Studio Marketplace"</a>. <i>marketplace.visualstudio.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-42"><span class="mw-cite-backlink"><b><a href="#cite_ref-42">^</a></b></span> <span class="reference-text"><cite id="CITEREFErikEJ" class="citation web cs1">ErikEJ. <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/core/extensions/">"Tools &amp; Extensions - EF Core"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
<li id="cite_note-43"><span class="mw-cite-backlink"><b><a href="#cite_ref-43">^</a></b></span> <span class="reference-text"><cite id="CITEREFajcvickers2022" class="citation web cs1">ajcvickers (9 March 2022). <a rel="nofollow" class="external text" href="https://learn.microsoft.com/en-us/ef/ef6/resources/tools">"Tools &amp; Extensions - EF6"</a>. <i>learn.microsoft.com</i><span class="reference-accessdate">. Retrieved <span class="nowrap">2022-12-12</span></span>.</cite></span>
</li>
</ol></div></div>
<div class="mw-heading mw-heading2"><h2 id="Bibliography">Bibliography</h2></div>
<style data-mw-deduplicate="TemplateStyles:r1239549316">
/* start https://en.wikipedia.org/ */


.mw-parser-output .refbegin{margin-bottom:0.5em}.mw-parser-output .refbegin-hanging-indents>ul{margin-left:0}.mw-parser-output .refbegin-hanging-indents>ul>li{margin-left:0;padding-left:3.2em;text-indent:-3.2em}.mw-parser-output .refbegin-hanging-indents ul,.mw-parser-output .refbegin-hanging-indents ul li{list-style:none}@media(max-width:720px){.mw-parser-output .refbegin-hanging-indents>ul>li{padding-left:1.6em;text-indent:-1.6em}}.mw-parser-output .refbegin-columns{margin-top:0.3em}.mw-parser-output .refbegin-columns ul{margin-top:0}.mw-parser-output .refbegin-columns li{page-break-inside:avoid;break-inside:avoid-column}@media screen{.mw-parser-output .refbegin{font-size:90%}}


/* end https://en.wikipedia.org/ */
</style><div class="refbegin" style="">
<ul><li><cite id="CITEREFLee2010" class="citation cs2">Lee, Craig (June 14, 2010), <a rel="nofollow" class="external text" href="https://web.archive.org/web/20121001210614/http://www.informit.com/store/product.aspx?isbn=0672330741"><i>ADO.NET Entity Framework Unleashed</i></a> (1st&nbsp;ed.), <a href="SAMS_Publishing" class="mw-redirect" title="SAMS Publishing">Sams</a>, p.&nbsp;600, <a href="ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a>&nbsp;<bdi>978-0-672-33074-2</bdi>, archived from <a rel="nofollow" class="external text" href="http://www.informit.com/store/product.aspx?isbn=0672330741">the original</a> on October 1, 2012</cite></li>
<li><cite id="CITEREFLerman2010" class="citation cs2">Lerman, Julia (August 2010), <a rel="nofollow" class="external text" href="http://oreilly.com/catalog/9780596807252/"><i>Programming Entity Framework</i></a> (2nd&nbsp;ed.), <a href="O'Reilly_Media" title="O'Reilly Media">O'Reilly Media</a>, p.&nbsp;912, <a href="ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a>&nbsp;<bdi>978-0-596-80726-9</bdi></cite></li>
<li><cite id="CITEREFJennings2009" class="citation cs2">Jennings, Roger (February 3, 2009), <a rel="nofollow" class="external text" href="https://web.archive.org/web/20121010093636/http://www.wiley.com/WileyCDA/WileyTitle/productCd-047018261X.html"><i>Professional ADO.NET 3.5 with LINQ and the Entity Framework</i></a> (1st&nbsp;ed.), <a href="Wrox_Press" title="Wrox Press">Wrox</a>, p.&nbsp;672, <a href="ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a>&nbsp;<bdi>978-0-470-18261-1</bdi>, archived from <a rel="nofollow" class="external text" href="http://www.wiley.com/WileyCDA/WileyTitle/productCd-047018261X.html">the original</a> on 2012-10-10<span class="reference-accessdate">, retrieved <span class="nowrap">2010-02-06</span></span></cite></li>
<li><cite id="CITEREFMostarda2010" class="citation cs2">Mostarda, Stefano (December 2010), <i>Entity Framework 4.0 in Action</i> (1st&nbsp;ed.), <a href="Manning_Publications" title="Manning Publications">Manning Publications</a>, p.&nbsp;450, <a href="ISBN_(identifier)" class="mw-redirect" title="ISBN (identifier)">ISBN</a>&nbsp;<bdi>978-1-935182-18-4</bdi></cite></li></ul>
</div>
<div class="mw-heading mw-heading2"><h2 id="External_links">External links</h2></div>
<style data-mw-deduplicate="TemplateStyles:r1290876196">
/* start https://en.wikipedia.org/ */


.mw-parser-output .side-box{margin:4px 0;box-sizing:border-box;border:1px solid #aaa;font-size:88%;line-height:1.25em;background-color:var(--background-color-interactive-subtle,#f8f9fa);display:flow-root}.mw-parser-output .infobox .side-box{font-size:100%}.mw-parser-output .side-box-abovebelow,.mw-parser-output .side-box-text{padding:0.25em 0.9em}.mw-parser-output .side-box-image{padding:2px 0 2px 0.9em;text-align:center}.mw-parser-output .side-box-imageright{padding:2px 0.9em 2px 0;text-align:center}@media(min-width:500px){.mw-parser-output .side-box-flex{display:flex;align-items:center}.mw-parser-output .side-box-text{flex:1;min-width:0}}@media(min-width:720px){.mw-parser-output .side-box{width:238px}.mw-parser-output .side-box-right{clear:right;float:right;margin-left:1em}.mw-parser-output .side-box-left{margin-right:1em}}


/* end https://en.wikipedia.org/ */
</style><style data-mw-deduplicate="TemplateStyles:r1237033735">
/* start https://en.wikipedia.org/ */


@media print{body.ns-0 .mw-parser-output .sistersitebox{display:none!important}}@media screen{html.skin-theme-clientpref-night .mw-parser-output .sistersitebox img[src*="Wiktionary-logo-en-v2.svg"]{background-color:white}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .sistersitebox img[src*="Wiktionary-logo-en-v2.svg"]{background-color:white}}


/* end https://en.wikipedia.org/ */
</style><div class="side-box side-box-right sistersitebox"><style data-mw-deduplicate="TemplateStyles:r1126788409">
/* start https://en.wikipedia.org/ */


.mw-parser-output .plainlist ol,.mw-parser-output .plainlist ul{line-height:inherit;list-style:none;margin:0;padding:0}.mw-parser-output .plainlist ol li,.mw-parser-output .plainlist ul li{margin-bottom:0}


/* end https://en.wikipedia.org/ */
</style>
<div class="side-box-flex">
<div class="side-box-image"><span class="noviewer" typeof="mw:File"></span></div>
<div class="side-box-text plainlist">Wikibooks has a book on the topic of: <i><b><a href="https://en.wikibooks.org/wiki/.NET_Development_Foundation" class="extiw external" title="wikibooks:.NET Development Foundation">.NET Development Foundation</a></b></i></div></div>
</div>
<ul><li><a rel="nofollow" class="external text" href="http://msdn.microsoft.com/en-us/data/ef.aspx">The ADO.NET Entity Framework (at Data Developer Center)</a></li>
<li><a rel="nofollow" class="external text" href="https://github.com/aspnet/EntityFramework">EntityFramework</a> on <a href="GitHub" title="GitHub">GitHub</a></li></ul>
<div class="navbox-styles"><style data-mw-deduplicate="TemplateStyles:r1129693374">
/* start https://en.wikipedia.org/ */


.mw-parser-output .hlist dl,.mw-parser-output .hlist ol,.mw-parser-output .hlist ul{margin:0;padding:0}.mw-parser-output .hlist dd,.mw-parser-output .hlist dt,.mw-parser-output .hlist li{margin:0;display:inline}.mw-parser-output .hlist.inline,.mw-parser-output .hlist.inline dl,.mw-parser-output .hlist.inline ol,.mw-parser-output .hlist.inline ul,.mw-parser-output .hlist dl dl,.mw-parser-output .hlist dl ol,.mw-parser-output .hlist dl ul,.mw-parser-output .hlist ol dl,.mw-parser-output .hlist ol ol,.mw-parser-output .hlist ol ul,.mw-parser-output .hlist ul dl,.mw-parser-output .hlist ul ol,.mw-parser-output .hlist ul ul{display:inline}.mw-parser-output .hlist .mw-empty-li{display:none}.mw-parser-output .hlist dt::after{content:": "}.mw-parser-output .hlist dd::after,.mw-parser-output .hlist li::after{content:" · ";font-weight:bold}.mw-parser-output .hlist dd:last-child::after,.mw-parser-output .hlist dt:last-child::after,.mw-parser-output .hlist li:last-child::after{content:none}.mw-parser-output .hlist dd dd:first-child::before,.mw-parser-output .hlist dd dt:first-child::before,.mw-parser-output .hlist dd li:first-child::before,.mw-parser-output .hlist dt dd:first-child::before,.mw-parser-output .hlist dt dt:first-child::before,.mw-parser-output .hlist dt li:first-child::before,.mw-parser-output .hlist li dd:first-child::before,.mw-parser-output .hlist li dt:first-child::before,.mw-parser-output .hlist li li:first-child::before{content:" (";font-weight:normal}.mw-parser-output .hlist dd dd:last-child::after,.mw-parser-output .hlist dd dt:last-child::after,.mw-parser-output .hlist dd li:last-child::after,.mw-parser-output .hlist dt dd:last-child::after,.mw-parser-output .hlist dt dt:last-child::after,.mw-parser-output .hlist dt li:last-child::after,.mw-parser-output .hlist li dd:last-child::after,.mw-parser-output .hlist li dt:last-child::after,.mw-parser-output .hlist li li:last-child::after{content:")";font-weight:normal}.mw-parser-output .hlist ol{counter-reset:listitem}.mw-parser-output .hlist ol>li{counter-increment:listitem}.mw-parser-output .hlist ol>li::before{content:" "counter(listitem)"\a0 "}.mw-parser-output .hlist dd ol>li:first-child::before,.mw-parser-output .hlist dt ol>li:first-child::before,.mw-parser-output .hlist li ol>li:first-child::before{content:" ("counter(listitem)"\a0 "}


/* end https://en.wikipedia.org/ */
</style><style data-mw-deduplicate="TemplateStyles:r1236075235">
/* start https://en.wikipedia.org/ */


.mw-parser-output .navbox{box-sizing:border-box;border:1px solid #a2a9b1;width:100%;clear:both;font-size:88%;text-align:center;padding:1px;margin:1em auto 0}.mw-parser-output .navbox .navbox{margin-top:0}.mw-parser-output .navbox+.navbox,.mw-parser-output .navbox+.navbox-styles+.navbox{margin-top:-1px}.mw-parser-output .navbox-inner,.mw-parser-output .navbox-subgroup{width:100%}.mw-parser-output .navbox-group,.mw-parser-output .navbox-title,.mw-parser-output .navbox-abovebelow{padding:0.25em 1em;line-height:1.5em;text-align:center}.mw-parser-output .navbox-group{white-space:nowrap;text-align:right}.mw-parser-output .navbox,.mw-parser-output .navbox-subgroup{background-color:#fdfdfd}.mw-parser-output .navbox-list{line-height:1.5em;border-color:#fdfdfd}.mw-parser-output .navbox-list-with-group{text-align:left;border-left-width:2px;border-left-style:solid}.mw-parser-output tr+tr>.navbox-abovebelow,.mw-parser-output tr+tr>.navbox-group,.mw-parser-output tr+tr>.navbox-image,.mw-parser-output tr+tr>.navbox-list{border-top:2px solid #fdfdfd}.mw-parser-output .navbox-title{background-color:#ccf}.mw-parser-output .navbox-abovebelow,.mw-parser-output .navbox-group,.mw-parser-output .navbox-subgroup .navbox-title{background-color:#ddf}.mw-parser-output .navbox-subgroup .navbox-group,.mw-parser-output .navbox-subgroup .navbox-abovebelow{background-color:#e6e6ff}.mw-parser-output .navbox-even{background-color:#f7f7f7}.mw-parser-output .navbox-odd{background-color:transparent}.mw-parser-output .navbox .hlist td dl,.mw-parser-output .navbox .hlist td ol,.mw-parser-output .navbox .hlist td ul,.mw-parser-output .navbox td.hlist dl,.mw-parser-output .navbox td.hlist ol,.mw-parser-output .navbox td.hlist ul{padding:0.125em 0}.mw-parser-output .navbox .navbar{display:block;font-size:100%}.mw-parser-output .navbox-title .navbar{float:left;text-align:left;margin-right:0.5em}body.skin--responsive .mw-parser-output .navbox-image img{max-width:none!important}@media print{body.ns-0 .mw-parser-output .navbox{display:none!important}}


/* end https://en.wikipedia.org/ */
</style></div><div role="navigation" class="navbox" aria-labelledby=".NET630" style="padding:3px"><table class="nowraplinks hlist mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><style data-mw-deduplicate="TemplateStyles:r1239400231">
/* start https://en.wikipedia.org/ */


.mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar-collapse{float:left;text-align:left}.mw-parser-output .navbar-boxtext{word-spacing:0}.mw-parser-output .navbar ul{display:inline-block;white-space:nowrap;line-height:inherit}.mw-parser-output .navbar-brackets::before{margin-right:-0.125em;content:"[ "}.mw-parser-output .navbar-brackets::after{margin-left:-0.125em;content:" ]"}.mw-parser-output .navbar li{word-spacing:-0.125em}.mw-parser-output .navbar a>span,.mw-parser-output .navbar a>abbr{text-decoration:inherit}.mw-parser-output .navbar-mini abbr{font-variant:small-caps;border-bottom:none;text-decoration:none;cursor:inherit}.mw-parser-output .navbar-ct-full{font-size:114%;margin:0 7em}.mw-parser-output .navbar-ct-mini{font-size:114%;margin:0 4em}html.skin-theme-clientpref-night .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}@media(prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .navbar li a abbr{color:var(--color-base)!important}}@media print{.mw-parser-output .navbar{display:none!important}}


/* end https://en.wikipedia.org/ */
</style><div id=".NET630" style="font-size:114%;margin:0 4em"><a href=".NET" title=".NET">.NET</a></div></th></tr><tr><td class="navbox-abovebelow" colspan="2"><div>
<ul><li><a href="Microsoft_.NET_strategy" title="Microsoft .NET strategy">.NET strategy</a></li>
<li><a href="List_of_.NET_libraries_and_frameworks" title="List of .NET libraries and frameworks">Libraries and frameworks</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Implementations</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href=".NET" title=".NET">.NET</a> (Core)</li>
<li><a href=".NET_Framework" title=".NET Framework">.NET Framework</a>
<ul><li><a href=".NET_Framework_version_history" title=".NET Framework version history">Version history</a></li></ul></li>
<li><a href=".NET_Compact_Framework" title=".NET Compact Framework">.NET Compact Framework</a></li>
<li><a href=".NET_Micro_Framework" title=".NET Micro Framework">.NET Micro Framework</a></li>
<li><a href="DotGNU" title="DotGNU">DotGNU</a></li>
<li><a href="Mono_(software)" title="Mono (software)">Mono</a></li>
<li><a href="XNA_Framework" class="mw-redirect" title="XNA Framework">XNA Framework</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Software_architecture" title="Software architecture">Architecture</a></th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Common_Language_Runtime" title="Common Language Runtime">Common Language Runtime</a> (CLR)</li>
<li><a href="COM_Interop" title="COM Interop">COM Interop</a></li>
<li><a href="Framework_Class_Library" title="Framework Class Library">Framework Class Library</a> (FCL)</li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Software_component" title="Software component">Components</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="ADO.NET" title="ADO.NET">ADO.NET</a>
<ul></ul></li>
<li><a href="ASP.NET" title="ASP.NET">ASP.NET</a>
<ul><li><a href="ASP.NET_Web_Forms" title="ASP.NET Web Forms">Web Forms</a></li>
<li><a href="ASP.NET_AJAX" title="ASP.NET AJAX">AJAX</a></li>
<li><a href="ASP.NET_Core" title="ASP.NET Core">Core</a></li>
<li><a href="ASP.NET_Dynamic_Data" title="ASP.NET Dynamic Data">Dynamic Data</a></li>
<li><a href="ASP.NET_MVC" title="ASP.NET MVC">MVC</a></li>
<li><a href="ASP.NET_Razor" title="ASP.NET Razor">Razor</a></li></ul></li>
<li><a href="Avalonia_(software_framework)" title="Avalonia (software framework)">Avalonia</a></li>
<li><a href="ClickOnce" title="ClickOnce">ClickOnce</a></li>
<li><a href="Dynamic_Language_Runtime" title="Dynamic Language Runtime">Dynamic Language Runtime</a></li>
<li><a href="Extensible_Application_Markup_Language" title="Extensible Application Markup Language">Extensible Application Markup Language</a> (XAML)</li>
<li><a href="Language_Integrated_Query" title="Language Integrated Query">Language Integrated Query</a> (LINQ)</li>
<li><a href="Managed_Extensibility_Framework" title="Managed Extensibility Framework">Managed Extensibility Framework</a></li>
<li><a href="Microsoft_Silverlight" title="Microsoft Silverlight">Microsoft Silverlight</a></li>
<li><a href="Microsoft_XNA" title="Microsoft XNA">Microsoft XNA</a></li>
<li><a href="Parallel_Extensions" title="Parallel Extensions">Parallel Extensions</a></li>
<li><a href="Windows_Communication_Foundation" title="Windows Communication Foundation">Windows Communication Foundation</a> (WCF)
<ul><li><a href="WCF_Data_Services" title="WCF Data Services">WCF Data Services</a></li></ul></li>
<li><a href="Windows_Forms" title="Windows Forms">Windows Forms</a> (WinForms)</li>
<li><a href="Windows_Identity_Foundation" title="Windows Identity Foundation">Windows Identity Foundation</a> (WIF)</li>
<li><a href="Windows_Presentation_Foundation" title="Windows Presentation Foundation">Windows Presentation Foundation</a> (WPF)</li>
<li><a href="Windows_Workflow_Foundation" title="Windows Workflow Foundation">Windows Workflow Foundation</a> (WF)</li>
<li><a href=".NET_Remoting" title=".NET Remoting">.NET Remoting</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Programming_tool" title="Programming tool">Tools</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Decompiler" title="Decompiler">Decompilers</a></th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href=".NET_Reflector" title=".NET Reflector">.NET Reflector</a></li>
<li><a href="JetBrains" title="JetBrains">dotPeek</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Obfuscation_(software)" title="Obfuscation (software)">Obfuscators</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Dotfuscator" title="Dotfuscator">Dotfuscator</a></li>
<li><a href="Redgate" title="Redgate">SmartAssembly</a></li></ul>
</div></td></tr><tr><td colspan="2" class="navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="CLR_Profiler" title="CLR Profiler">CLR Profiler</a></li>
<li><a href="ILAsm" title="ILAsm">ILAsm</a></li>
<li><a href=".NET_Compiler_Platform" class="mw-redirect" title=".NET Compiler Platform">.NET Compiler Platform</a></li>
<li><a href="Native_Image_Generator" title="Native Image Generator">Native Image Generator</a> (NGen)</li>
<li><a href="XAMLPad" class="mw-redirect" title="XAMLPad">XAMLPad</a></li></ul>
</div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Integrated_development_environment" title="Integrated development environment">IDEs</a></th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Microsoft_Visual_Studio" class="mw-redirect" title="Microsoft Visual Studio">Visual Studio</a>
<ul><li><a href="Microsoft_Blend" title="Microsoft Blend">Blend</a></li>
<li><a href="Microsoft_Visual_Studio_Express" title="Microsoft Visual Studio Express">Express</a></li></ul></li>
<li><a href="MonoDevelop" title="MonoDevelop">MonoDevelop</a></li>
<li><a href="SharpDevelop" title="SharpDevelop">SharpDevelop</a></li>
<li><a href="Xamarin_Studio" class="mw-redirect" title="Xamarin Studio">Xamarin Studio</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Organizations</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href=".NET_Foundation" title=".NET Foundation">.NET Foundation</a></li>
<li><a href="Microsoft" title="Microsoft">Microsoft</a></li>
<li><a href="Xamarin" title="Xamarin">Xamarin</a></li></ul>
</div></td></tr><tr><td class="navbox-abovebelow" colspan="2"><div>
<ul><li><span class="noviewer" typeof="mw:File"><span title="Category"></span></span> Category</li>
<li><span class="noviewer" typeof="mw:File"><span title="List-Class article"></span></span> <a href=".NET_Framework_version_history" title=".NET Framework version history">List</a></li>
<li><span class="noviewer" typeof="mw:File"><span title="Commons page"></span></span> <a href="https://commons.wikimedia.org/wiki/Category:.NET" class="extiw external" title="commons:Category:.NET">Commons</a></li></ul>
</div></td></tr></tbody></table></div>
<div class="navbox-styles"></div><div role="navigation" class="navbox" aria-labelledby="Microsoft_APIs_and_frameworks486" style="padding:3px"><table class="nowraplinks mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><div id="Microsoft_APIs_and_frameworks486" style="font-size:114%;margin:0 4em"><a href="List_of_Microsoft_Windows_application_programming_interfaces_and_frameworks" title="List of Microsoft Windows application programming interfaces and frameworks">Microsoft APIs and frameworks</a></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Graphics and UI</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Desktop_Window_Manager" title="Desktop Window Manager">Desktop Window Manager</a></li>
<li><a href="Direct2D" title="Direct2D">Direct2D</a></li>
<li><a href="Direct3D" title="Direct3D">Direct3D</a></li>
<li><a href="D3DX" title="D3DX">D3D (extensions)</a></li>
<li><a href="Graphics_Device_Interface" title="Graphics Device Interface">GDI / GDI+</a></li>
<li><a href="Windows_Presentation_Foundation" title="Windows Presentation Foundation">WPF</a></li>
<li><a href="Microsoft_Silverlight" title="Microsoft Silverlight">Silverlight</a></li>
<li><a href="Windows_UI_Library" title="Windows UI Library">WinUI</a></li>
<li><a href="Windows_Color_System" title="Windows Color System">Windows Color System</a></li>
<li><a href="Windows_Image_Acquisition" title="Windows Image Acquisition">Windows Image Acquisition</a></li>
<li><a href="Windows_Imaging_Component" title="Windows Imaging Component">Windows Imaging Component</a></li>
<li><a href="DirectX_Graphics_Infrastructure" title="DirectX Graphics Infrastructure">DirectX Graphics Infrastructure (DXGI)</a></li>
<li><a href="Windows_Advanced_Rasterization_Platform" title="Windows Advanced Rasterization Platform">Windows Advanced Rasterization Platform</a></li>
<li><a href="WinG" title="WinG">WinG</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Audio</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="DirectMusic" title="DirectMusic">DirectMusic</a></li>
<li><a href="DirectSound" title="DirectSound">DirectSound</a></li>
<li><a href="Cross-platform_Audio_Creation_Tool" title="Cross-platform Audio Creation Tool">XACT</a></li>
<li><a href="Microsoft_Speech_API" title="Microsoft Speech API">Speech API</a></li>
<li><a href="XAudio2" title="XAudio2">XAudio2</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Multimedia</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="DirectX" title="DirectX">DirectX</a>
<ul><li><a href="DirectX_Media_Objects" class="mw-redirect" title="DirectX Media Objects">Media Objects</a></li>
<li><a href="DirectX_Video_Acceleration" title="DirectX Video Acceleration">Video Acceleration</a></li></ul></li>
<li><a href="Xinput" class="mw-redirect" title="Xinput">Xinput</a></li>
<li><a href="DirectInput" title="DirectInput">DirectInput</a></li>
<li><a href="DirectShow" title="DirectShow">DirectShow</a></li>
<li><a href="Managed_DirectX" title="Managed DirectX">Managed DirectX</a></li>
<li><a href="Media_Foundation" title="Media Foundation">Media Foundation</a></li>
<li><a href="Microsoft_XNA" title="Microsoft XNA">XNA</a></li>
<li><a href="Windows_Media" title="Windows Media">Windows Media</a></li>
<li><a href="Video_for_Windows" title="Video for Windows">Video for Windows</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Web</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Trident_(software)" title="Trident (software)">MSHTML</a></li>
<li><a href="JScript" title="JScript">JScript</a></li>
<li><a href="VBScript" title="VBScript">VBScript</a></li>
<li><a href="Browser_Helper_Object" title="Browser Helper Object">BHO</a></li>
<li><a href="XMLHttpRequest" title="XMLHttpRequest">XDR</a></li>
<li><a href="Microsoft_Gadgets" title="Microsoft Gadgets">SideBar Gadgets</a></li>
<li><a href="TypeScript" title="TypeScript">TypeScript</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Data access</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Microsoft_Data_Access_Components" title="Microsoft Data Access Components">Data Access Components (MDAC)</a>
<ul><li><a href="ActiveX_Data_Objects" title="ActiveX Data Objects">ADO</a></li>
<li><a href="ADO.NET" title="ADO.NET">ADO.NET</a></li>
<li><a href="ODBC" class="mw-redirect" title="ODBC">ODBC</a></li>
<li><a href="OLE_DB" title="OLE DB">OLE DB</a></li></ul></li>
<li><a href="Extensible_Storage_Engine" title="Extensible Storage Engine">Extensible Storage Engine</a></li>

<li><a href="Microsoft_Sync_Framework" title="Microsoft Sync Framework">Sync Framework</a></li>
<li><a href="Access_Database_Engine" title="Access Database Engine">Access Database Engine</a></li>
<li><a href="MSXML" title="MSXML">MSXML</a></li>
<li><a href="Open_Packaging_Conventions" title="Open Packaging Conventions">OPC</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Networking</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Winsock" title="Winsock">Winsock</a>
<ul><li><a href="Layered_Service_Provider" title="Layered Service Provider">LSP</a></li></ul></li>
<li><a href="Windows_Vista_networking_technologies#Winsock_Kernel" title="Windows Vista networking technologies">Winsock Kernel</a></li>
<li><a href="Windows_Filtering_Platform" title="Windows Filtering Platform">Filtering Platform</a></li>
<li><a href="Network_Driver_Interface_Specification" title="Network Driver Interface Specification">NDIS</a></li>
<li><a href="Windows_Rally" title="Windows Rally">Windows Rally</a></li>
<li><a href="Background_Intelligent_Transfer_Service" title="Background Intelligent Transfer Service">BITS</a></li>
<li><a href="Windows_Vista_networking_technologies#Peer-to-peer_communication" title="Windows Vista networking technologies">P2P API</a></li>
<li><a href="Microsoft_Message_Queuing" title="Microsoft Message Queuing">MSMQ</a></li>
<li><a href="DirectPlay" title="DirectPlay">DirectPlay</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Communication</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="MAPI" title="MAPI">Messaging API</a></li>
<li><a href="Telephony_Application_Programming_Interface" title="Telephony Application Programming Interface">Telephony API</a></li>
<li><a href="Windows_Communication_Foundation" title="Windows Communication Foundation">WCF</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Administration and<br>management</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Win32_console" class="mw-redirect" title="Win32 console">Win32 console</a></li>
<li><a href="Windows_Script_Host" title="Windows Script Host">Windows Script Host</a></li>
<li><a href="Windows_Management_Instrumentation" title="Windows Management Instrumentation">WMI (extensions)</a></li>
<li><a href="PowerShell" title="PowerShell">PowerShell</a></li>
<li><a href="Windows_Task_Scheduler" title="Windows Task Scheduler">Task Scheduler</a></li>
<li><a href="Windows_Vista_I/O_technologies#Offline_Files" title="Windows Vista I/O technologies">Offline Files</a></li>
<li><a href="Shadow_Copy" title="Shadow Copy">Shadow Copy</a></li>
<li><a href="Windows_Installer" title="Windows Installer">Windows Installer</a></li>
<li><a href="Windows_Error_Reporting" title="Windows Error Reporting">Error Reporting</a></li>
<li><a href="Event_Viewer#Windows_Event_Log" title="Event Viewer">Event Log</a></li>
<li><a href="Common_Log_File_System" title="Common Log File System">Common Log File System</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em"><a href="Component-based_software_engineering" title="Component-based software engineering">Component model</a></th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Component_Object_Model" title="Component Object Model">COM</a></li>
<li><a href="Component_Object_Model#COM+" title="Component Object Model">COM+</a></li>
<li><a href="ActiveX" title="ActiveX">ActiveX</a></li>
<li><a href="Distributed_Component_Object_Model" title="Distributed Component Object Model">Distributed Component Object Model</a></li>
<li><a href=".NET_Framework" title=".NET Framework">.NET Framework</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em"><a href="Library_(computing)" title="Library (computing)">Libraries</a></th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Framework_Class_Library" title="Framework Class Library">Framework Class Library</a></li>
<li><a href="Microsoft_Foundation_Class_Library" title="Microsoft Foundation Class Library">Microsoft Foundation Classes (MFC)</a></li>
<li><a href="Active_Template_Library" title="Active Template Library">Active Template Library (ATL)</a></li>
<li><a href="Windows_Template_Library" title="Windows Template Library">Windows Template Library (WTL)</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em"><a href="Device_driver" title="Device driver">Device drivers</a></th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Windows_Driver_Model" title="Windows Driver Model">WDM</a></li>
<li><a href="Windows_Driver_Frameworks" title="Windows Driver Frameworks">WDF</a>
<ul><li><a href="Kernel-Mode_Driver_Framework" title="Kernel-Mode Driver Framework">KMDF</a></li>
<li><a href="User-Mode_Driver_Framework" title="User-Mode Driver Framework">UMDF</a></li></ul></li>
<li><a href="Windows_Display_Driver_Model" title="Windows Display Driver Model">WDDM</a></li>
<li><a href="Network_Driver_Interface_Specification" title="Network Driver Interface Specification">NDIS</a></li>
<li><a href="Universal_Audio_Architecture" title="Universal Audio Architecture">UAA</a></li>
<li><a href="VxD" title="VxD">VxD</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Security</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Microsoft_CryptoAPI" title="Microsoft CryptoAPI">Crypto API</a>
<ul><li><a href="CAPICOM" title="CAPICOM">CAPICOM</a></li></ul></li>
<li><a href="Windows_CardSpace" title="Windows CardSpace">Windows CardSpace</a></li>
<li><a href="Data_Protection_API" title="Data Protection API">Data Protection API</a></li>
<li><a href="Security_Support_Provider_Interface" title="Security Support Provider Interface">Security Support Provider Interface (SSPI)</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em"><a href=".NET_Framework" title=".NET Framework">.NET</a></th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="ASP.NET" title="ASP.NET">ASP.NET</a></li>
<li><a href="ADO.NET" title="ADO.NET">ADO.NET</a></li>
<li><a href=".NET_Remoting" title=".NET Remoting">Remoting</a></li>
<li><a href="Microsoft_Silverlight" title="Microsoft Silverlight">Silverlight</a></li>
<li><a href="Task_Parallel_Library" class="mw-redirect" title="Task Parallel Library">TPL</a></li>
<li><a href="Windows_Communication_Foundation" title="Windows Communication Foundation">WCF</a></li>
<li><a href="Windows_CardSpace" title="Windows CardSpace">WCS</a></li>
<li><a href="Windows_Presentation_Foundation" title="Windows Presentation Foundation">WPF</a></li>
<li><a href="Windows_Workflow_Foundation" title="Windows Workflow Foundation">WF</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em"><a href="Software_Factory_(Microsoft_.NET)" class="mw-redirect" title="Software Factory (Microsoft .NET)">Software factories</a></th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Microsoft_Enterprise_Library" title="Microsoft Enterprise Library">Enterprise Library</a></li>
<li><a href="Microsoft_Customer_Care_Framework" title="Microsoft Customer Care Framework">CCF</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em"><a href="Inter-process_communication" title="Inter-process communication">IPC</a></th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Microsoft_RPC" title="Microsoft RPC">MSRPC</a></li>
<li><a href="Dynamic_Data_Exchange" title="Dynamic Data Exchange">Dynamic Data Exchange (DDE)</a></li>
<li><a href=".NET_Remoting" title=".NET Remoting">Remoting</a></li>
<li><a href="Windows_Communication_Foundation" title="Windows Communication Foundation">WCF</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Accessibility</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Microsoft_Active_Accessibility" title="Microsoft Active Accessibility">Active Accessibility</a></li>
<li><a href="Microsoft_UI_Automation" title="Microsoft UI Automation">UI Automation</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;line-height:1.2em">Text and multilingual<br>support</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="DirectWrite" title="DirectWrite">DirectWrite</a></li>
<li><a href="Text_Services_Framework" title="Text Services Framework">Text Services Framework</a></li>
<li><a href="Text_Object_Model" title="Text Object Model">Text Object Model</a></li>
<li><a href="Input_method" title="Input method">Input method editor</a></li>
<li><a href="Language_Interface_Pack" title="Language Interface Pack">Language Interface Pack</a></li>
<li><a href="Multilingual_User_Interface" title="Multilingual User Interface">Multilingual User Interface</a></li>
<li><a href="Uniscribe" title="Uniscribe">Uniscribe</a></li></ul>
</div></td></tr></tbody></table></div>
<div class="navbox-styles"></div><div role="navigation" class="navbox" aria-labelledby="Microsoft_free_and_open-source_software_(FOSS)290" style="padding:3px"><table class="nowraplinks mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><div id="Microsoft_free_and_open-source_software_(FOSS)290" style="font-size:114%;margin:0 4em"><a href="Microsoft" title="Microsoft">Microsoft</a> <a href="Free_and_open-source_software" title="Free and open-source software">free and open-source software (FOSS)</a></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Overview</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Microsoft_and_open_source" title="Microsoft and open source">Microsoft and open source</a></li>
<li><a href="Shared_Source_Initiative" title="Shared Source Initiative">Shared Source Initiative</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Software</th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em"></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Applications</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="3D_Movie_Maker" title="3D Movie Maker">3D Movie Maker</a></li>
<li><a href="Atom_(text_editor)" title="Atom (text editor)">Atom</a></li>
<li><a href="Conference_XP" title="Conference XP">Conference XP</a></li>
<li><a href="Family.Show" title="Family.Show">Family.Show</a></li>
<li><a href="File_Manager_(Windows)" class="mw-redirect" title="File Manager (Windows)">File Manager</a></li>
<li><a href="Open_Live_Writer" title="Open Live Writer">Open Live Writer</a></li>
<li><a href="Microsoft_Edit" class="mw-redirect" title="Microsoft Edit">Microsoft Edit</a></li>
<li><a href="Microsoft_PowerToys" title="Microsoft PowerToys">Microsoft PowerToys</a></li>
<li><a href="Windows_Terminal" title="Windows Terminal">Terminal</a></li>
<li><a href="Windows_Calculator" title="Windows Calculator">Windows Calculator</a></li>
<li><a href="Windows_Console" title="Windows Console">Windows Console</a></li>
<li><a href="Windows_Package_Manager" title="Windows Package Manager">Windows Package Manager</a></li>
<li><a href="WorldWide_Telescope" title="WorldWide Telescope">WorldWide Telescope</a></li>
<li><a href="XML_Notepad" title="XML Notepad">XML Notepad</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Video games</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Allegiance_(video_game)" title="Allegiance (video game)">Allegiance</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Programming<br>languages</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Bosque_(programming_language)" title="Bosque (programming language)">Bosque</a></li>
<li><a href="C_Sharp_(programming_language)" title="C Sharp (programming language)">C#</a></li>
<li><a href="Dafny" title="Dafny">Dafny</a></li>
<li><a href="F_Sharp_(programming_language)" title="F Sharp (programming language)">F#</a></li>
<li><a href="F*_(programming_language)" title="F* (programming language)">F*</a></li>
<li><a href="GW-BASIC" title="GW-BASIC">GW-BASIC</a></li>
<li><a href="IronPython" title="IronPython">IronPython</a></li>
<li><a href="IronRuby" title="IronRuby">IronRuby</a></li>
<li><a href="Lean_(proof_assistant)" title="Lean (proof assistant)">Lean</a></li>
<li><a href="P_(programming_language)" title="P (programming language)">P</a></li>
<li><a href="Microsoft_Power_Fx" title="Microsoft Power Fx">Power Fx</a></li>
<li><a href="PowerShell" title="PowerShell">PowerShell</a></li>
<li><a href="Project_Verona" title="Project Verona">Project Verona</a></li>
<li><a href="Q_Sharp" title="Q Sharp">Q#</a></li>
<li><a href="Microsoft_Small_Basic" title="Microsoft Small Basic">Small Basic Online</a></li>
<li><a href="TypeScript" title="TypeScript">TypeScript</a></li>
<li><a href="Visual_Basic_.NET" class="mw-redirect" title="Visual Basic .NET">Visual Basic</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Frameworks,<br>development tools</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href=".NET" title=".NET">.NET</a></li>
<li><a href=".NET_Framework" title=".NET Framework">.NET Framework</a></li>
<li><a href=".NET_Gadgeteer" title=".NET Gadgeteer">.NET Gadgeteer</a></li>
<li><a href=".NET_MAUI" class="mw-redirect" title=".NET MAUI">.NET MAUI</a></li>
<li><a href=".NET_Micro_Framework" title=".NET Micro Framework">.NET Micro Framework</a></li>
<li><a href="AirSim" title="AirSim">AirSim</a></li>
<li><a href="ASP.NET" title="ASP.NET">ASP.NET</a></li>
<li><a href="ASP.NET_AJAX" title="ASP.NET AJAX">ASP.NET AJAX</a></li>
<li><a href="ASP.NET_Core" title="ASP.NET Core">ASP.NET Core</a></li>
<li><a href="ASP.NET_MVC" title="ASP.NET MVC">ASP.NET MVC</a></li>
<li><a href="ASP.NET_Razor" title="ASP.NET Razor">ASP.NET Razor</a></li>
<li><a href="ASP.NET_Web_Forms" title="ASP.NET Web Forms">ASP.NET Web Forms</a></li>
<li><a href="Avalonia_(software_framework)" title="Avalonia (software framework)">Avalonia</a></li>
<li><a href="Babylon.js" title="Babylon.js">Babylon.js</a></li>
<li><a href="BitFunnel" title="BitFunnel">BitFunnel</a></li>
<li><a href="Blazor" title="Blazor">Blazor</a></li>
<li><a href="C%2B%2B/WinRT" title="C++/WinRT">C++/WinRT</a></li>
<li><a href="Confidential_Consortium_Framework" title="Confidential Consortium Framework">CCF</a></li>
<li><a href="Chakra_(JavaScript_engine)" title="Chakra (JavaScript engine)">ChakraCore</a></li>
<li><a href="CLR_Profiler" title="CLR Profiler">CLR Profiler</a></li>
<li><a href="Dapr" title="Dapr">Dapr</a></li>
<li><a href="DeepSpeed" title="DeepSpeed">DeepSpeed</a></li>
<li><a href="DiskSpd" title="DiskSpd">DiskSpd</a></li>
<li><a href="Dryad_(programming)" title="Dryad (programming)">Dryad</a></li>
<li><a href="Dynamic_Language_Runtime" title="Dynamic Language Runtime">Dynamic Language Runtime</a></li>
<li><a href="EBPF_on_Windows" class="mw-redirect" title="EBPF on Windows">eBPF on Windows</a></li>
<li><a href="Electron_(software_framework)" title="Electron (software framework)">Electron</a></li>

<li><a href="Fluent_Design_System" title="Fluent Design System">Fluent Design System</a></li>
<li><a href="Fluid_Framework" title="Fluid Framework">Fluid Framework</a></li>
<li><a href="Infer.NET" title="Infer.NET">Infer.NET</a></li>
<li><a href="LightGBM" title="LightGBM">LightGBM</a></li>
<li><a href="Managed_Extensibility_Framework" title="Managed Extensibility Framework">Managed Extensibility Framework</a></li>
<li><a href="Microsoft_Automatic_Graph_Layout" title="Microsoft Automatic Graph Layout">Microsoft Automatic Graph Layout</a></li>
<li><a href="Microsoft_C%2B%2B_Standard_Library" class="mw-redirect" title="Microsoft C++ Standard Library">Microsoft C++ Standard Library</a></li>
<li><a href="Microsoft_Cognitive_Toolkit" title="Microsoft Cognitive Toolkit">Microsoft Cognitive Toolkit</a></li>
<li><a href="Metro_(design_language)" title="Metro (design language)">Microsoft Design Language</a></li>
<li><a href="Microsoft_Detours" title="Microsoft Detours">Microsoft Detours</a></li>
<li><a href="Microsoft_Enterprise_Library" title="Microsoft Enterprise Library">Microsoft Enterprise Library</a></li>
<li><a href="Microsoft_SEAL" title="Microsoft SEAL">Microsoft SEAL</a></li>
<li><a href="Mimalloc" title="Mimalloc">mimalloc</a></li>
<li><a href="Mixed_Reality_Toolkit" title="Mixed Reality Toolkit">Mixed Reality Toolkit</a></li>
<li><a href="ML.NET" title="ML.NET">ML.NET</a></li>
<li><a href="Mod_mono" title="Mod mono">mod_mono</a></li>
<li><a href="Mono_(software)" title="Mono (software)">Mono</a></li>
<li><a href="MonoDevelop" title="MonoDevelop">MonoDevelop</a></li>
<li><a href="MSBuild" title="MSBuild">MSBuild</a></li>
<li><a href="MsQuic" title="MsQuic">MsQuic</a></li>
<li><a href="Neural_Network_Intelligence" title="Neural Network Intelligence">Neural Network Intelligence</a></li>
<li><a href="Npm" title="Npm">npm</a></li>
<li><a href="NuGet" title="NuGet">NuGet</a></li>
<li><a href="OneFuzz" title="OneFuzz">OneFuzz</a></li>
<li><a href="Open_Management_Infrastructure" title="Open Management Infrastructure">Open Management Infrastructure</a></li>
<li><a href="Open_Neural_Network_Exchange" title="Open Neural Network Exchange">Open Neural Network Exchange</a></li>
<li><a href="Open_Service_Mesh" title="Open Service Mesh">Open Service Mesh</a></li>
<li><a href="Open_XML_SDK" class="mw-redirect" title="Open XML SDK">Open XML SDK</a></li>
<li><a href="Orleans_(software_framework)" title="Orleans (software framework)">Orleans</a></li>
<li><a href="Playwright_(software)" title="Playwright (software)">Playwright</a></li>
<li><a href="ProcDump" title="ProcDump">ProcDump</a></li>
<li><a href="Process_Monitor" title="Process Monitor">ProcMon</a></li>
<li><a href="Python_Tools_for_Visual_Studio" title="Python Tools for Visual Studio">Python Tools for Visual Studio</a></li>
<li><a href="R_Tools_for_Visual_Studio" title="R Tools for Visual Studio">R Tools for Visual Studio</a></li>
<li><a href="RecursiveExtractor" class="mw-redirect" title="RecursiveExtractor">RecursiveExtractor</a></li>
<li><a href="Roslyn_(compiler)" title="Roslyn (compiler)">Roslyn</a></li>
<li><a href="Sandcastle_(software)" title="Sandcastle (software)">Sandcastle</a></li>
<li><a href="SignalR" title="SignalR">SignalR</a></li>
<li><a href="StyleCop" title="StyleCop">StyleCop</a></li>
<li><a href="SVNBridge" title="SVNBridge">SVNBridge</a></li>
<li><a href="T2_Temporal_Prover" title="T2 Temporal Prover">T2 Temporal Prover</a></li>
<li><a href="Text_Template_Transformation_Toolkit" title="Text Template Transformation Toolkit">Text Template Transformation Toolkit</a></li>
<li><a href="TLA%2B_Toolbox" class="mw-redirect" title="TLA+ Toolbox">TLA+ Toolbox</a></li>
<li><a href="U-Prove" title="U-Prove">U-Prove</a></li>
<li><a href="Vcpkg" title="Vcpkg">vcpkg</a></li>
<li><a href="Virtual_File_System_for_Git" title="Virtual File System for Git">Virtual File System for Git</a></li>
<li><a href="Voldemort_(distributed_data_store)" title="Voldemort (distributed data store)">Voldemort</a></li>
<li><a href="VoTT" title="VoTT">VoTT</a></li>
<li><a href="Vowpal_Wabbit" title="Vowpal Wabbit">Vowpal Wabbit</a></li>
<li><a href="Windows_App_SDK" title="Windows App SDK">Windows App SDK</a></li>
<li><a href="Windows_Communication_Foundation" title="Windows Communication Foundation">Windows Communication Foundation</a></li>
<li><a href="Windows_Driver_Frameworks" title="Windows Driver Frameworks">Windows Driver Frameworks</a>
<ul><li><a href="Kernel-Mode_Driver_Framework" title="Kernel-Mode Driver Framework">KMDF</a></li>
<li><a href="User-Mode_Driver_Framework" title="User-Mode Driver Framework">UMDF</a></li></ul></li>
<li><a href="Windows_Forms" title="Windows Forms">Windows Forms</a></li>
<li><a href="Windows_Presentation_Foundation" title="Windows Presentation Foundation">Windows Presentation Foundation</a></li>
<li><a href="Windows_Template_Library" title="Windows Template Library">Windows Template Library</a></li>
<li><a href="Windows_UI_Library" title="Windows UI Library">Windows UI Library</a></li>
<li><a href="WinJS" title="WinJS">WinJS</a></li>
<li><a href="WinObjC" class="mw-redirect" title="WinObjC">WinObjC</a></li>
<li><a href="WiX" title="WiX">WiX</a></li>
<li><a href="XDP_for_Windows" class="mw-redirect" title="XDP for Windows">XDP for Windows</a></li>
<li><a href="XSP_(software)" title="XSP (software)">XSP</a></li>
<li><a href="XUnit.net" title="XUnit.net">xUnit.net</a></li>
<li><a href="Z3_Theorem_Prover" title="Z3 Theorem Prover">Z3 Theorem Prover</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Operating systems</th><td class="navbox-list-with-group navbox-list navbox-even" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="MS-DOS" title="MS-DOS">MS-DOS</a> (v1.25, v2.0 &amp; v4.0)</li>
<li><a href="Barrelfish_(operating_system)" title="Barrelfish (operating system)">Barrelfish</a></li>
<li><a href="SONiC_(operating_system)" title="SONiC (operating system)">SONiC</a></li>
<li><a href="Azure_Linux" title="Azure Linux">Azure Linux</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Other</th><td class="navbox-list-with-group navbox-list navbox-odd" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="ChronoZoom" title="ChronoZoom">ChronoZoom</a></li>
<li><a href="Extensible_Storage_Engine" title="Extensible Storage Engine">Extensible Storage Engine</a></li>
<li><a href="FlexWiki" class="mw-redirect" title="FlexWiki">FlexWiki</a></li>
<li><a href="FourQ" title="FourQ">FourQ</a></li>
<li><a href="Gollum_(software)" title="Gollum (software)">Gollum</a></li>
<li><a href="Project_Mu" class="mw-redirect" title="Project Mu">Project Mu</a></li>
<li><a href="ReactiveX" title="ReactiveX">ReactiveX</a></li>
<li><a href="SILK" title="SILK">SILK</a></li>
<li><a href="TLAPS" class="mw-redirect" title="TLAPS">TLAPS</a></li>
<li><a href="TPM_2.0_Reference_Implementation" class="mw-redirect" title="TPM 2.0 Reference Implementation">TPM 2.0 Reference Implementation</a></li>
<li><a href="WikiBhasha" title="WikiBhasha">WikiBhasha</a></li>
<li><a href="Windows_Subsystem_for_Linux" title="Windows Subsystem for Linux">Windows Subsystem for Linux</a></li></ul>
</div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Open-source_license" title="Open-source license">Licenses</a></th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="Microsoft_Public_License" class="mw-redirect" title="Microsoft Public License">Microsoft Public License</a></li>
<li><a href="Microsoft_Reciprocal_License" class="mw-redirect" title="Microsoft Reciprocal License">Microsoft Reciprocal License</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%"><a href="Forge_(software)" title="Forge (software)">Forges</a></th><td class="navbox-list-with-group navbox-list navbox-odd hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href="CodePlex" title="CodePlex">CodePlex</a></li>
<li><a href="GitHub" title="GitHub">GitHub</a></li></ul>
</div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Related</th><td class="navbox-list-with-group navbox-list navbox-even hlist" style="width:100%;padding:0"><div style="padding:0 0.25em">
<ul><li><a href=".NET_Foundation" title=".NET Foundation">.NET Foundation</a></li>
<li><a href="F_Sharp_Software_Foundation" title="F Sharp Software Foundation">F# Software Foundation</a></li>
<li><a href="Microsoft_Open_Specification_Promise" title="Microsoft Open Specification Promise">Microsoft Open Specification Promise</a></li>
<li><a href="Open_Letter_to_Hobbyists" class="mw-redirect" title="Open Letter to Hobbyists">Open Letter to Hobbyists</a></li>
<li><a href="Open_Source_Security_Foundation" title="Open Source Security Foundation">Open Source Security Foundation</a></li>
<li><a href="Outercurve_Foundation" title="Outercurve Foundation">Outercurve Foundation</a></li></ul>
</div></td></tr><tr><td class="navbox-abovebelow" colspan="2"><div><span class="noviewer" typeof="mw:File"><span title="Category"></span></span> Category</div></td></tr></tbody></table></div></div><!--htdig_noindex--><div><div class="zim-footer">
This article is issued from <a class="external text" title="Last edited on 2025-06-25" href="https://en.wikipedia.org/wiki/?title=Entity_Framework&amp;oldid=1297374871">Wikipedia</a>. The text is available under <a class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-Share Alike 4.0</a> unless otherwise noted. Additional terms may apply for the media files.
</div>
</div><!--/htdig_noindex--></div>
</div>
</main>
</div>
</div>
</div>

</body></html>